jeanfrancoismelancon
asked on
3 datagrids linked trought data environment
I have 3 datagrids linked together via data environment:
dgCustomer is parent to dgContact, dgContact is parent to dgInvoice.
It is working well when the form loads... the dg3 reprensents the dgInvoice shows the records for the selected Contact and the dgContact shows the good contact for the selected customer.
The problem: as soon as I select another customer, the good contact are shown in the dgContact but the dgInvoice is empty... and stays this way even when I go back to the first customer... this dataGrid is empty except on the formLoad.
Anyone as an idea?
dgCustomer is parent to dgContact, dgContact is parent to dgInvoice.
It is working well when the form loads... the dg3 reprensents the dgInvoice shows the records for the selected Contact and the dgContact shows the good contact for the selected customer.
The problem: as soon as I select another customer, the good contact are shown in the dgContact but the dgInvoice is empty... and stays this way even when I go back to the first customer... this dataGrid is empty except on the formLoad.
Anyone as an idea?
Éric Moreau
Show you code that refresh the grids.
ASKER
No code is necessary to refresh the grids with the dataEnvironment
Have you created hierarcical commands? What I suggest is that you use the DataForm wizard to generate a Master/Detail form and look at the code when changing record. You will see that some code is required to refresh the grids.
ASKER
But then way is it working very well with 2 dataGrids?
Is your hierarchie well formed?
ASKER
Yes, it is well formed. When I change an Invoice, then I requery the recordset and re-bind the dataGrids, it is working again, but the same thing appens as on formLoad.
Any Idea?
Any Idea?
So you have some code! Show it.
ASKER
Yes but the code I have is only when I update some data... but the problem I have is when I click on my dgCustomer... the dgContact refreshes correctly, but with the dgInvoice nothing appens. And I do nothing much (or less) between those two.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I know I can make it work using something else than the data Environment... but I want to use the date Environment because there is no code to make it work... all I want to know is if it works properly.
This question appears to be abandoned. A question regarding it will be left in the CleanUp
area; if you have any comment about the question, please leave it here.
Unless there is objection or further activity, one of the moderators will be asked to accept the comment
of <emoreau>.
DO NOT ACCEPT THIS COMMENT AS AN ANSWER.
area; if you have any comment about the question, please leave it here.
Unless there is objection or further activity, one of the moderators will be asked to accept the comment
of <emoreau>.
DO NOT ACCEPT THIS COMMENT AS AN ANSWER.
