>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!!!
Don't try to put all data into the same grid. Either select all notaries for particular client, or all clients for particualr notary, i.e. your app could have different forms/grids for different views.
Edward Pikman
Independent Consultant