Relationship links missing!!

[Trevor Howard]

Please HELP!

I opened my relationship window to find all the links missing between tables, other than between four tables, which I had imported to my working db from my test db two weeks ago.

The strange thing is that my db seems to work, original forms and tables work fine, as if relationships are in place. I can restore my links manually if need be as I keep whole db backups which will show me my original link structure (pre the import I made). I am concerned why this happened and if I am about to loss data integrity.

Thanks!
Trevor

 

[dcx693]

I'd be concerned about why this happened. Sounds very strange. As to your database still working, it might just be that you haven't realized that something isn't working. The relationsihps window is where you specify if you need to enforce referential integrity and cascading updates and deletions. You cannot specify those in a query or anywhere else.

 

[Trevor Howard]

Hi dcx693,

This is what is bothering me, I have tested at different levels of data entry and deleting, but nothing seems amiss. I am sure it happened at the time of the import, I checked back over several backups till the import and all are missing relationship links, but the one immediately before my import is fine. I make a new backup copy most nights, so this was easy to confirm.

I suppose I could establish my links & referential integrity and hope everything is ok, but WHAT could have gone wrong, this is always the concern.

Thanks dcx693 for your help, any ideas are appreciated.

 

[dcx693]

Exactly what kind of import did you do?

 

[Trevor Howard]

I did a “get external data” and imported tables and forms.

Obviously I didn’t check ALL my program after the import, some how the links were deleted, but the db appeared to be working after the import. How it could I just don’t know. I just happened to look at my relationship form today and found it.

I have now established my links on the original tables and found my final link to the new tables defective. With the link in place I get an error when opening my customer contacts table, this is where my new service table links into;

“The record source ‘SELECT tblProspects.(IDNumber), tblProspects.(Company Name) FROM tblProspects;’ specified on this form or report does not exist”

Removed the link and alls well in my customer contacts table. I think I have got away with out corrupting my data, but a near call! I will now rethink.

Sorry for all this text, I was in a real panic. I hope there are no lasting problems. ???

 

[Trevor Howard]

Hello dcx693,

OK, I have found that since the import;, when a main form (Customer) is deleted with a delet function, with its sub form (Contacts) the entry in the Customer table is deleted but the contacts remain on the Contacts table, since the referential integrity was removed for cascade deleting. This is stopping me setting referential integrity between the two tables until I remove this redundant data.

Is there a query or other method to look for redundant data in this table?

Thanks for your help

 

[dcx693]

Run a query that looks for records on one table that do not exist on the other. Sounds like you need to look for Contacts that don't exist in the customer table.

 

[Trevor Howard]

dcx693, I will do that. I was in a cold sweet yesterday, it could have been much worse.

Thank you again.