Two combo boxes tied together on data set

  • Thread starter Thread starter Brian Henry
  • Start date Start date
B

Brian Henry

If I have two tables in a data set say like this


Table1
======
ItemID
Name

Table2
=======
SubItemID
ParentItemID
Name

and they are referenced together on the dataset table2.parentitemid =
table1.itemID

if I have a list of all the items in table 1 listed in cboTable1 and that is
tied to the data table table1, and i want it to show its sub items from
table2 in cboTable2 (second combo box) based on the referential integirty
how can i use the reference to do this? thanks
 
right now im doing it with a data view, but wondered if there was an easer
way by just referencing the referencial integrity constraing in the data
set...
 
Back
Top