Solved

Form development

Posted on 2013-01-01
2
207 Views
Last Modified: 2013-01-01
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...
0
Comment
Question by:pdvsa
2 Comments
 
LVL 57

Accepted Solution

by:
Jim Dettman (Microsoft MVP/ EE MVE) earned 500 total points
Comment Utility
<<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
 

Author Comment

by:pdvsa
Comment Utility
ok thank you Jim.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now