Referential Integrity problem

[rbrule]

Hello,
I have a new database with two tables, one of which is a linked table. I want to link the two using a one to many relationship from one table to the other.

I have a primary key field in the main table which is an autonumber, and a foriegn key field in the second table which is a number type. The field size is long integer. When I go into the relationship view to set up the relationship, I dragged the primary key field from one table to the foriegn key field in the other table. The create relationship dialog box comes up, but it does not allow me to set Referential Integrity. The Access help indicates that the database of the linked table must be open, in order to establish Referential integrity betwee a linked table and a local table. I tried that and still could not establish Referential integrity. The dialog box does not give an error message, the check box for Referential integrity is just grayed out.

Has anyone had this problem, if so what was the fix? I have never had this happen before.

Thank you

 

[Ian Mac]

It sounds like you have data in table 2 which isn't in table 1 (Primary table)

 

[rbrule]

Thank you, that is kind of what I thought.