troubleshooting Question

Form development

Avatar of pdvsa
pdvsaFlag for United States of America asked on
Microsoft Access
2 Comments1 Solution265 ViewsLast Modified:
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...
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros