Microsoft Access

[bms]

I am new learner on Access. I have 2 tables that I have set up with a
relationship. I wanted to "enforce referential integrity" but I get an error
message saying it can't as it violates the rules. I have done my best to
locate the difference between the primery key and matching field, but cannot
find the problem Is there anyway of getting Access to highlight the exact
problem to me? Thanks

[VHG]

From working with relational tables a few years ago I believe for referential integrity to work both columns need to be "key" columns.

I have not used Access so dont know the terminology, but dont you need one Primary key in one table linked to a Foreign key in another table.

Explained here

http://en.wikipedia.org/wiki/Referential_integ rity