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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Joining two tables 2
XML So Close I Can Taste It 1
[Newbie] data acces with ado 2
Putting data to data grid 2
Access MS ACCESS, Compare two similar tables 1
SQL: create a table with recursive relationship 4
Data Table Selecting 14

Back
Top