Is there anything I could have done that would remove my relationships? Maybe making a copy of form to update DB or running some VBA?
No big deal, Just want to know if anything will effect or remove them.
Thanks,
Tom
Is there anything I could have done that would remove my relationships? Maybe making a copy of form to update DB or running some VBA?
No big deal, Just want to know if anything will effect or remove them.
Thanks,
Tom
did you click the ALL RELATIONSHIPS button?
sometimes they like to hide.
Sorry I don't seeALL RELATIONSHIPS button.
Hi Tom
Database Tools - Relationships and then the Ribbon will show these options:-
Do you have a recent database backup with relationships? Is this a split database?
Not a split DB. Maybe I saved from a split DB? I do have older copies that have relationships. Have made many changes along the way.
Thanks
Hi Tom
Can you zip and share the Db to see if anyone else gets the same outcome?
I could share my DB, but only to see missing relationships. I added the relationships back and no big problem. Just wanted to know what would delete them? Maybe a change in one of my tables? PK haven't changed. I make copies when I make changes.
Thanks,
Tom
Update! Maybe sometime back I wanted to update a table from another DB and I had to delete relationships in order to copy into. newest DB.
Not a problem now.
Thanks!
Tom