I cannot add new record to select query

[Denise]

How do I troubleshoot a 2 table query that will not allow new records to be
added? Both tables allow new records. But the tables combined will not.

 

[Stefan Hoffmann]

hi Denise,

How do I troubleshoot a 2 table query that will not allow new records to be
added? Both tables allow new records. But the tables combined will not.

A SELECT query must be key-preserving for Access/Jet to append new
records. This means:

a) Each table used to built the query must have a primary key.
Try adding the primary key fields from each table to your query.

b) The SELECT query must not be "complex". Some query operations
(grouping, joins, sub-selects) may lead to a query which is not updatable.

If a) don't work, you may post your select SQL statement.


mfG
--> stefan <--

 

[Keith Wilby]

How do I troubleshoot a 2 table query that will not allow new records to
be
added? Both tables allow new records. But the tables combined will not.

The query is not updatable. Might be a join problem, more info needed.

Keith.
www.keithwilby.co.uk