Query Design

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

Guest

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?
 
When creating a query of out of two tables with a one to many relationship,
should you include both linked fields in the query?
Click to expand...

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?
Click to expand...

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]
 
Back
Top