Referential integrity in a relationship

Question

Hello, I have the following problem. I would like to create a 1:n relationship with referential integrity between the tables. Table "Anschrift" has "Angebotsnummer" as the primary key, table "Hauptübersicht" has the same field only not as the primary key. Unfortunately, I can't select referential integrity. In an older version it was still possible, I would be so happy if someone has an idea why that could be.

Answer 1

Hi,

You have to create all relationships in the backend where the tables reside. "Relationships" between linked tables created in the frontend are just nice drawings.

Servus
Karl
-------
Access Bug Trackers
Access News
Access DevCon

Answer 2

Hi,

Are you trying this in the database where both tables physically reside? If a linked table is involved, RI is never selectable as RI can't be managed for other files.

Servus
Karl
-------
Access Bug Trackers
Access News
Access DevCon

Answer 3

Thanks for your answer. I try it in a front end file, the tables are in the back end file. Funnily enough, there are two other tables where the relationship is there and which RI also contains. Do you think I can't create a new relationship with RI after the split?

Servus
Carolin

Answer 4

Oh yes, that makes perfect sense.
That really helped me and it works wonderfully in the back end. Thanks a lot!

Servus
Carolin