Primary Key

[Heavenly Hash]

The Employee Id is to have the data type of the auto number and must be a
primary key. The fields are set to refernetial integrity, cascade and delete.

But it doesnt want to join...why is that ?
It worked before.........

 

[Sergey Poberezovskiy]

Access may refuse to set referential integrity constraint
when existing data violates it. Run a query to see
whether you have Employee ID in your foreign key field
that does not exist in the Employees table.

HTH.

 

[Jeff Boyce]

Not much to go on... so this is only a guess.

First, "fields" are not set to referential integrity, the joins
(relationships) are.

Second, if you have referential integrity set between two tables, they are
already "joined". What does "it doesn't want to join" mean? Where? In a
query? In the relationships window?