Eight Subforms or One Query?

[gnt]

I have a master form with 8 tabsheets on it. Each tabsheet will contain data from a different table, and each table is related to the main table. I think I have 2 options:

1) Create 8 subforms based directly on the tables and then place these subforms on the tabsheets, or

2) create one query joining all the tables together and then base the master form on that.

I can't seem to find a clear reason why one way is better than the other. I'm partial to the query as I hate subforms. Any arguments would be appreciated.

Thanks-

 

[thornmastr]

I understand your partiality toward the query and if possible would favor that approach. The only problem is proving the feasibility of your choice. A relatively easy action.

Create the query external to any form.

Run the query and attempt to change a few values in any record. If your query is updateable, you’ve made a good choice. If it is not, begin designing eight sub forms.
Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com

 

[gnt]

Thanks!
I'll give it a try-
The only problem is, I want a couple of the tabsheets to display multiple records in datasheet view - so I may be stuck with the subform there.
Thanks again.