How to enter data into a multiple table query

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

Guest

I have created a select query with several fields from 2 tables and the
results are excellent apart from the fact that as well as viewing this
information I would like to add new records to this query which will update
the relevant tables.
Can someone tell me if this is possible and if not some way around it.
Any help will be appreciated.
 
Sara Jane,

You have most likely included two tables with a one-to-many relationship
between them, which is why Access won't let you add records.
Generally, queries are not meant for data input, even though they will
let you do so when you don't create a non-updatable recordset (like with
a one-to-many relationship). The way to enter new data is through forms,
based directly on tables. In these cases (two tables witha one-to-many
relationship:
Make a form for the many side table;
Make a form for the one side table;
In the latter, add the former as a subform, and follow the subform
wizard steps to join the two on the common field.

HTH,
Nikos
 
Back
Top