I need help. I have an Access database with 4 tables. Table1 contains 2 fields, CompanyID and Company Name. Table2 has 3 fields, DivisionID, Division Name, and CompanyID. Table3 has 3 fields, DepartmentID, Department Name, and DivisionID. Table4 has 3 fields, ExtID, Ext Name, DeptartmentID.
The tables have referencial integrity by the ID fields.
I can use ADO to open Table1 fine. I can use ADO to open Table1 as it relates to Table2. But thats where it stops. I cant figure how to open Table1, Table2, and Table3(or Table4) for use as a front end for the user.

The wanted end result is a series of forms where the user will enter Company Names to Table1 by itself. Then he will enter Divisions to Table2, selecting from the Company Names(field2 of Table1) he created to make an association Company/Division. Then he will enter divisions to Table3, after selecting the Company/Division combination he created in Table2, ,resulting in a Company/Division/Department association.


Any help would be appreciated.