Can't edit my query

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


--
Nothing is Lost.

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.
--
Dave Hargis, Microsoft Access MVP


"MorrisPoet" wrote:

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


--
Nothing is Lost.

On Fri, 19 Jun 2009 11:47:02 -0700, MorrisPoet
wrote:

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

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.
--

John W. Vinson [MVP]