referential integrity with relationships

[whoknows361]

hello all.. cant seem to figure this out.. and i know its porbably an easy one. I have 2 tables.. One with an ID (autoincrement) and also has a bunch of other fields in it (name, address, etc.)..

have table 2 which has only 2 fields.. one is ID (the autoincrement) and the second is diagnosis.

I went to relationships window.. related the ID fields of both tables and tried to do referential integrity, both with updates and deletes. but it either tells me that there is no field in common between tables.. or sometimes it tells me that table 1 is in use by another process (which it isnt). what am I missing in regards to referential integrity. Where is a good place to learn how to do this correctly? Thanks

Jonathan

 

[PHV]

The ID field in table 2 shouldn't be autoincrement but Numeric Long

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fneily]

You might want to search these Access forums and google for why using autonumbering can complicate things. Seems your case found one. Nothing wrong with making up your own primary key.