About updating data in a query whose tables have a one-to-many relationship
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
If a query is based on a one-to-many relationship, you might not be able to edit the data in the query's results. The following table lists the types of fields that you might not be able to modify, and, when appropriate, alternative methods for updating them.
| Type of field | Solution |
|---|---|
| Join field from the "one" side | Enable cascading updates between the two tables. For more information, click aa199552(v=office.10).md. |
| New records, if the "many" side join field doesn't appear in the datasheet | Add the join field from the "many" side to your query to allow adding new records. |
| Join field from the "many" side, after you've updated data on the "one" side | Save the record; then you'll be able to make changes to the "many" side join field. |
| Blank field from the table on the "one" side of a one-to-many relationship where an outer join exists | Enter values in fields from the table on the "many" side, but only if the joined field from the "one" side contains a value for that record. |
| New records, if entire unique key of ODBC table isn't output | Select all primary key fields of ODBC tables to allow inserts into them. |