why I can't input in the query

[J.Jiang]

Hi,

I have 2 tables, one is "shop", and one is "shop application", when I¡¡make
a query from these two tables which are connected by "shop ID" field, I
can't input in the query, can somebody tell me why?

Thanks a lot.

Jane

 

[Baz]

Make sure that (i) the shopID field is the primary key on the "shop" table,
and (ii) that the "shopID" field from the "shop application" table is
included in the query's SELECT list.

 

[BruceM]

Here is a summary of possible reasons why the query is not updatable:
http://allenbrowne.com/ser-61.html

A Shop form with a Shop Application subform may be the way to go,
particularly if Shop and Shop Application are related one-to-many.

 

[J.Jiang]

Thank you.

Yes, I found I didn't set primary key of shop ID.