Query Design

[Steve]

When creating a query of out of two tables with a one to many relationship,
should you include both linked fields in the query? Can you use a query when
adding records to the many side or do you recommend binding the form to a
table?

 

[John Vinson]

When creating a query of out of two tables with a one to many relationship,
should you include both linked fields in the query?

You can do so; you must indeed do so if you want to be able to update
both tables.

Can you use a query when
adding records to the many side or do you recommend binding the form to a
table?

You can use a joined query if you wish, but it's usually simpler to
use a Form for the "one" side table and a Subform for the "many". You
can (and often will) use a single-table query rather than the table
directly; this lets you set the sort order, select which fields you
want to see, include calculated fields etc. Use some sort of Form in
any case - table and query datasheets are of limited utility and
should not be used for data entry or editing.


John W. Vinson[MVP]