Primary Key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.........
 
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.
 
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?
 
Back
Top