Query Design

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?

On Sun, 27 Nov 2005 18:25:05 -0800, "Steve"
wrote:

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]