Access - Make Links Reciprocal
November 22, 2022 9:57 AM Subscribe
I have linked fields in access -- projects and partners. This partner is on this project. That project has these partners. But access doesn't know these are reciprocal relationships. Like I can on the projects table select which partners are on that project OR on the partners table select which projects that partner is on, but whichever I do, the other table won't reflect it. How do I make the tables reflect each other correctly? Feel free to point me, instead, to a youtube or linked-in learning course that will cover these sort of moderately-advanced access functions (or that will give me the correct language to google them).