[AccessD] One-to-one relationships

Hi All,

I have four tables, one is the "main" table and the other three are category
or type tables with a one-to-one relationship to the "main" table.

I want to limit a record that is in the "main" table to exist in only one of
the category tables with the flexibility of the record moving, if you will,
from one category table to another. For example, if during the creation of a
new record the user picks category1 from a combo box, he/she is presented
with the fields that are found in the category1 table. If at a later point
he/she decides to change the category to category2, the information from
category1 would be removed and the user would fill in the information for
category2.

I have coded this before and everything worked out well, but what I was
wondering is if the ability to limiting to one category table could be
achieved using some form a relationship rules in Access. Or can this only be
accomplished with coding?

Thanks!

Joe Rojas
jrojas at tnco-inc.com





This electronic transmission is strictly confidential to TNCO, Inc. and
intended solely for the addressee. It may contain information which is
covered by legal, professional, or other privileges. If you are not the
intended addressee, or someone authorized by the intended addressee to
receive transmissions on behalf of the addressee, you must not retain,
disclose in any form, copy, or take any action in reliance on this
transmission. If you have received this transmission in error, please notify
the sender as soon as possible and destroy this message. While TNCO, Inc.
uses virus protection, the recipient should check this email and any
attachments for the presence of viruses. TNCO, Inc. accepts no liability for
any damage caused by any virus transmitted by this email.