query based on two tables

[Guest]

Do I have theright concept of a query? In order to create a data input form
that has most of the fields from one table but a few fields from another
table you must create a query, I'm guessing a select query, with all the
fields needed from both tables and then base the form on the query.

Is this correct?
thanks,

 

[Larry Linson]

Do I have theright concept of a query? In order
to create a data input form that has most of the
fields from one table but a few fields from another
table you must create a query, I'm guessing a
select query, with all the fields needed from both
tables and then base the form on the query.

And, there most probably will be a relationship between records in the two
tables -- fields that you will use to match which records "go together."
Access has the Query Builder to make it easy to create queries. You'll find
some useful introductory online training links at
http://office.microsoft.com that might be helpful -- they don't, or didn't
last time I looked, go as far as VBA code, but cover the basics very nicely.

Larry Linson
Microsoft Access MVP

 

[Jeff Boyce]

Janis

How are the tables related? That is, why would it make sense to have some
fields from table1 AND some fields from table2 on the same form?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[John Vinson]

Do I have theright concept of a query? In order to create a data input form
that has most of the fields from one table but a few fields from another
table you must create a query, I'm guessing a select query, with all the
fields needed from both tables and then base the form on the query.

Is this correct?
thanks,

Generally, for *updating*, one would NOT create a QUery joining the
two tables. Instead, typically one would use a Form based on the "one"
side table of the relationship and a Subform based on the "many". If
your tables are related one-to-one (having the same Primary Key) then
you need to ask yourself why you're using two tables instead of
combining the fields into one.

John W. Vinson[MVP]