Can't edit my query

[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

 

[Klatuu]

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.

 

[John W. Vinson]

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.

 

[MGFoster]

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!

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

What you have done is called attribute splitting - a common error for
beginners. I suggest you merge those tables back to one table with the
added column of SOMETHING_DESCRIPTIVE_type for "tracking," "mailing,"
and "QC information." The "SOMETHING_DESCRIPTIVE" could be "address" or
something else that describes the type.

HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBSjvxMIechKqOuFEgEQJnzgCgw4QspKccnaC4CBDCb4AFVVQVJTIAn2i6
rEH33RuWTF2pfnEAHvktoe57
=TkDJ
-----END PGP SIGNATURE-----