Driving Multiple Tables from One Main Form...

[kart_deBlonch]

Driving Multiple Tables from One form:

I am designing a database that will have about 17 tables for data in it along with about 15 tables for lookup lists. I would like to have one main form for editing and entering data in about 15 of the 17 data tables. I have read somewhere about doing this. How is this done without joining all the tables together in a query? I don’t want to involve a query because, based on trial and error, I can’t get comboboxes to work when the record source for the form is a query. Or, if I use a query as the record source, I have to use sub-forms for the comboboxes, which I would rather not do. Thanks everybody!

 

[kart_deBlonch]

After taking a closer look at some of the design elements of the Orders form in the Northwind db, I guess I have resolved my issues with this 'problem'. Next time I will do more than 'trial and error' before I raise issues on this site. But, I am still a little curious as to how one form might drive the data in multiple tables. Any ideas?