Two combo boxes tied together on data set

[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

[Brian Henry]

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...
"Brian Henry" <brianiup[nospam]@adelphia.net> wrote in message
news:%2***************@TK2MSFTNGP12.phx.gbl...

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