Cannot add new record with query

[Chris]

I have a query with 3 tables joint together. I cannot add any new record
(The new record button is not enabled). However, it allow me to add new
record if the query only have 2 tables. Do I missing something?

Thanks
Chris

 

[Dirk Goldgar]

I have a query with 3 tables joint together. I cannot add any new
record (The new record button is not enabled). However, it allow me
to add new record if the query only have 2 tables. Do I missing
something?

See the help file topic, "When can I update data from a query?"

 

[chas]

Hi Chris,

adding the third table is making the resulting
recordset 'non-updateable'

for some rules about creating updatable queries search
Access help for 'updatable' (without the quotes).

hth

chas

 

[chas]

Hi Chris,

this can sometimes occur with multiple tables in a query.
Search Access help for 'updatable' (without the quotes)
for a discussion of the circumstances.

hth

chas