Form development

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...
pdvsaProject financeAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:
<<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.
0
 
pdvsaProject financeAuthor Commented:
ok thank you Jim.
0
All Courses

From novice to tech pro — start learning today.