why only 2 tables: 1 query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

1. How come one can not make a good query based on more than 2 tables so as
to allow a person to make a decent form that contains all necessary fields?
2. The object of data normalizing is to breakdown the objects onto the
smallest unit for reliability, etc.. if so, how does one go about creating a
data entry form (w/ all fields needed) if the queries used can only at most
be based on only 2 tables? Thank you for your help.
 
Why do you say that a query can only contain two tables if you want to use
that query for a form's Record Source? That is not a correct statement for
every situation. There are constraints on how you must write a query that is
updatable (meaning that you can edit data via it), but that does not mean
that you are limited to two tables.

You'll need to tell us a lot more details about what you're trying to do.
 
1. How come one can not make a good query based on more than 2 tables so as
to allow a person to make a decent form that contains all necessary fields?
Click to expand...

What makes you think that Access has any such limitation?

A Form can be based on a multitable query (with appropriate care); if
you have one to many relationships a Form with subforms, including
nested subforms, can be used to update multiple tables.
2. The object of data normalizing is to breakdown the objects onto the
smallest unit for reliability, etc.. if so, how does one go about creating a
data entry form (w/ all fields needed) if the queries used can only at most
be based on only 2 tables? Thank you for your help.
Click to expand...

By using the full capabilities of Forms, which you apparently are not
yet doing.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top