Form development

pdvsa
pdvsa used Ask the Experts™
on
Experts,

Its not advisable to make a form with a subform built off of the same tables?  
I ask because displaying all information in the form might make the form hard to read.  i have seen professionally built databases where you click on a part of the form and other areas (subforms) update.  Is each subform typically built off of a separate table?  I believe so however a separate query to find data in those forms and subforms could require all of the other subform tables.  I mean you would have to drag in all of those separate tables, correct?   I guess it shouldnt be a big deal if all the tables were linked properly.  

if the form was instead just built off of 1 table then queries would require only 1 table,, correct?   I am trying to figure out the benefit of having multiple tables i/o havin 1 table (in this case).

thanks...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
<<Is each subform typically built off of a separate table?  >>

 Yes.  The whole idea of a main/subform combination is that you have a parent record related to one or more child records in another table.

 There is no reason to use a main/subform combination for a single table unless your trying to do something with a table that relates to itself.

If you need a better layout of a form for a single table, you want to use a tab control.

Jim.
pdvsaProject finance

Author

Commented:
ok thank you Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial