General information
Category:
Coding, syntax & commands
Title:
Grid Refresh, Synchonize View and table
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!!!
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only