I have 2 tables created in my app, one for clients and the second for their dependants. I've created a table to table relationship between the two tables with many dependants belonging to one customer. However, the dependant may belong to two customers, as often times our clients are spouses of each other. On the client table, we list the spouse under each client.
What I need to do is when I enter a dependant, it generally shows up under the primary client on the client's details. I'd like it to also show up under the spouse's details as the child belongs to both clients.