Can't edit data in query

[MIke Collard]

MS Access help suggests it should be possible to edit data
in a one to one query but I get 'This recordset is not
updateable'. Any clues?

Thanks

Mike Collard

 

[Jay]

Try making sure that the fields you are using to connect
the tables in the query are primary keys. If both can not
be one is better than non. Next try to use outer joins
instead of a inner join. Usually if I do these few things
I can edit my query dynaset.

Hope this helps.

Jay

 

[TC]

What is the primary key of each table?

TC