[AccessD] One-to-one relationships

Joe

Unless your "main" table only has three records - one for each category 
table - then I believe you have one-to-many relationships between the main 
table and each of the category tables. FYI.

When you are in a form (?) and you select - for example - category 1, and 
the associated fields are displayed, where is this data stored? Do you have 
a fifth table that stores the child records, with the main table and the 
category table as foreign keys? Or is the main table already a foreign key 
in each of the category tables?

In general, if you have enforced referential integrity for cascade-deletes, 
changing the category will automatically "remove" the child record that was 
created when you selected the original category.

Regards,
Bob Gajewski


On Thursday, April 03, 2003 12:12 PM, Joe Rojas [SMTP:JRojas at tnco-inc.com] 
wrote:
> 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
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>