The combo box with the department number info is an ado bound to the department table.

The listbox with subdept info is an ado bound to the subdepartment table.

I have been trying to link them together, but I can't even get the darn tables to open in design mode. The instuctions I have say that I can open the data view, select my data link, expand that all the way so that I can see all the table names, then right click on the table icon of my choice. I will then supposedly see 'design' and from there I can go on to set up relations between my tables. But there is no selection for design when I right click on my table icon.