Current Position Inside a Related Table

S

sp00n

New member
Joined
Jun 7, 2003
Messages
1
I have three tables: Customer, Order, Order Details.

I need to get the current row that is selected in a DataGrid when browsing the Order Table.

They are related like so:

Customer --> Order --> Order Details

I can browse and edit the tables with a DataGrid.

Its easy to get the current position when browsing the customer table:

Code: 
Dim x as Integer = Me.BindingContext(DsAll1, "Customer").Position

However, If I click on a customer, and then navigate to its related records in the Order Table, and try to get the position:

Code: 
Dim OrderTablePosition as Integer = Me.BindingContext(DsAll1, "Order").Position

This does not work.

Does anyone know how? Have I explained my situation clearly?

Thanks,
spoon
 
Back
Top