How to edit data in a query to update the table?

[Guest]

(Access 2002)
I have a select query that shows jobs that we need to inspect. One of the
columns is to add a check mark upon inspection. Unfortunately, I can not
change or add and data or check marks within this query. The only problem I
can see is that in the design view I have to tables showing with 2
relationships from 1 to the other. These are necessary in order to populate
a supervisor field with the appropriate supervisor name per location to be
inspected. The "join" properties are #2-- "Include ALL records from
'Schedule' and only those records from 'Subdivisions' where the joined fields
are equal". If I delete this relationship, I can edit data in the query or
add the appropiate check marks but I loose the valuable relationship that
tells us which supervisor handles each inspection as per the 'Schedule' /
'Subdivison' relationships. Any ideas on how to remedy this?

 

[John Vinson]

(Access 2002)
I have a select query that shows jobs that we need to inspect. One of the
columns is to add a check mark upon inspection. Unfortunately, I can not
change or add and data or check marks within this query. The only problem I
can see is that in the design view I have to tables showing with 2
relationships from 1 to the other. These are necessary in order to populate
a supervisor field with the appropriate supervisor name per location to be
inspected. The "join" properties are #2-- "Include ALL records from
'Schedule' and only those records from 'Subdivisions' where the joined fields
are equal". If I delete this relationship, I can edit data in the query or
add the appropiate check marks but I loose the valuable relationship that
tells us which supervisor handles each inspection as per the 'Schedule' /
'Subdivison' relationships. Any ideas on how to remedy this?

Please open the query in SQL view and post the SQL text here. Do you
have a unique Index on the "one" table joining fields in each table?

Ordinarily you would not open a query datasheet *AT ALL*, much less
attempt to edit in a query; can you instead use a Form with subforms
for the related tables? This would have each form editable.

John W. Vinson[MVP]