Links Between Tables keep breaking down
Operating system version
Windows NT / Windows 7
Description of the issue
I have a database with over 50 tables, which are connected to each other through different pathways, to allow for portals and other links to work.
These data in portals keeps disappearing/not allowing entry, and I have to go into the "edit relationship" box on each link and delete and re-enter the relationship. It then rebuilds the dependencies.
What causes this and how can I stop this happening?