I have a question regarding whether datagrids (and DataViews) can
support automatic synchronization between a child and parent (i.e.
based on being on a child record, automatically position the parent).
Parent to Child relationships are obviously supported. I am looking
for the opposite relationship. To setup the example I used two tables
similar to the Orders and Order Items tables in the Microsoft Northwind
demo database. I noticed that I can setup two datagrids and show the
Orders in one grid and (using the relationship for the second
Datagrid)the Order Details in the second grid. Changing from one order
to another automatically keeps the OrderItems in sych.
My question is whether I can setup this scenario in the opposite
direction. Can I display all the OrderItems (for all orders) in one
grid and automatically have the Orders table position itself on the
Parent (i.e. Order) for the OrderItem I have selected?
I am thinking that this relationship synchronization is not supported.
The reason is that I noticed that when I setup a datagrid with
navigation turned on and position myself on a parent table, the child
relationships are displayed. However, when I show a child table in the
datagrid, I get no relationships displayed.
Does anyone have any insight into this problem? I have worked several
angles on this problem and all the solutions require a lot of code (and
I still don't have it working).
Jerry
(E-Mail Removed)
Similar Threads
