Can't edit my query

  • Thread starter Thread starter MorrisPoet
  • Start date Start date
M

MorrisPoet

Folks:

A while back I created a table with a form to help me manage the production
of my office's correspondence; recently, I broke the table up into three by
topic: tracking, mailing, and QC information. I created 1-to-1 relationships
between the tables and a new query. The result: the query is not updatable.
Help says that as long as the relationships are 1 to 1, I should be able to
edit--any ideas what the problem could be? Thanks in advance for letting me
know!

MP
 
Not necessarily. There are several reasons a query may not be editable. For
example, a UNION query can never be updated. Without seeing it, I can't say
why it is not; however, you first mistake was breaking up the tables. This
will actually create more problems than it will solve. You have only found
one so far. The correct thing to do would be leave it as one table and add a
field the identifies to which group the record belongs. Use queries to
return the records you want.
 
Folks:

A while back I created a table with a form to help me manage the production
of my office's correspondence; recently, I broke the table up into three by
topic: tracking, mailing, and QC information. I created 1-to-1 relationships
between the tables and a new query. The result: the query is not updatable.
Help says that as long as the relationships are 1 to 1, I should be able to
edit--any ideas what the problem could be? Thanks in advance for letting me
know!

MP
Click to expand...

Do you have a unique Index on the joining fields in both tables? If not, add
such indexes.

If so please open the query in SQL view and post it here.
 
Back
Top