First, I really appreciate your help. I have looked at this from so many differnt ways, I cant see the forest, for the trees in the way.

If you could expand on this a little more, I think I will have it.

1)When a user opens the "Company" form. All he gets is a listing of the Company table, with edit/add/delete capabilities.(This is working now using an ADODC and text boxes).

2)When the user opens the "Division" form, he will have to select the correct Company, then it should show all Divisions currently referenced to that Company, and give him the ability to edit/add/delete only the Division table.

(This is where I get lost)
3)When the user opens the "Department" form, he will have to select from the Company, then from the Divisions associated with the selected Company. And he will need the ability to edit/add/delete only from the Deptartment table.

4)etc.............

The tables are
Company:CompanyID,Company_Name
Division:DivisionID, Division_Name, CompanyID
Department:DepartmentID, Department_Name, DivisionID
Extension:ExtID, Ext_Name, DepartmentID