I always have troubles when i got a many to many relation between
2 tables. Example this 3 tables Notary-Jonction-Clients.
one notary could have many clients, and one client could by associate
to many notary. Everything is good with the design, but when i have
to choose the recordsource for the grid i got a lot of questions :

1- Do i use a Querry, a view or directly the table client with a filter on the jonction table? Why the relation between the tables does not show me all client records associate to my notary on the grid?

I have to coding a lot, when i am adding clients records or delete records clients. Why, I got to refresh the grid, requery, this.recordsource=this.recordsource (with view and querry).

I am adding or deleting records in the jonction table and after
i loose the synchronization with the table client.
You have surely a way to redure coding!!!