Linked Table Relationship Help Needed

[Wong]

I have a database that has a linked table within it. I need to enforce referential integrity on this relationship but it won't allow me too.

Does anyone know if this can be done?

If so, could you possibly point me in the right direction

Thanks

 

[Wong]

Linked Table Relationship Problem

Thanks for replying Pat

I have actually found some info which you had replied to earlier, so much for having a good look!!
I have done as you suggested and imported the tbl from the FE into the BE and tried to create the 1 to Many relationship there, unfortunately because there is data in one of the tables it will not let me enforce referential integrity.

I have copied the structure of the table and then tried to append the date, but not all of the data has been appended due to Key Violations.

I'm stuck now, could you suggest anything else to try???


thanks

 

[RuralGuy]

PMFJI but it looks like Pat has stepped out for a bit. I'm sure she will comment when she gets back.

...unfortunately because there is data in one of the tables it will not let me enforce referential integrity.

I believe you will find that RI could be turned on if there were no RI violations in the tables. You may wish to examine the data for problems and use the Duplicates and Unmatched queries from the wizard to assist.