Master/Detail/Detail (3 Level Relationship) Data Binding

Master/Detail/Detail (3 Level Relationship) Data Binding

Post by LT1CM049L » Mon, 23 Jul 2007 12:04:00

Hi, If I have a Master-Detail table Relationship, I can have a combobox for
the Master table and one for the Detail table, which updates its contents
depending on the current Master selection. I do this by binding the Master
combobox directly to the Master table, and the Detail combobox directly to
the FK_Master_Detail1 relationship.

However, if I have a third table (detail2) with a detail relationship to the
detail1 table (three levels of hierarchy), binding to the FK_Detail1_Detail2
won't work, because detail1 is bound to a relationship, and not the table
itself, and so it won't update the third combobox according to the selection
in the second combobox, which contents depends on the first combobox (make

Looking for a way around this. Eg, can I make the second combobox update the
currently selected row in the table to which the foreign key it is bound to
gets its data from, so the third combo picks this up?

Master/Detail/Detail (3 Level Relationship) Data Binding

Post by QnJlbm5vbi » Tue, 24 Jul 2007 07:24:00


This post may help you by explaining a process of 3 tier binding.. if
anything, it may give you some answers..
Hope it helps