Cemetery Table Question

[jake]

I still working on my funeral home program!?!
The first table (Vitals) is used on every case...the next table
(Cemetery) is used approx 50% of the time...they are ralated one to
one.

My question: what is the proper way to set up the relationship.
Enforce Referential Integrity (yes or no)
Cascade Updated Related Fields (yes or no)
Cascase Delete Related Fields (yes or no)

Thank you Jake

 

[John Vinson]

I still working on my funeral home program!?!
The first table (Vitals) is used on every case...the next table
(Cemetery) is used approx 50% of the time...they are ralated one to
one.

My question: what is the proper way to set up the relationship.
Enforce Referential Integrity (yes or no)
Cascade Updated Related Fields (yes or no)
Cascase Delete Related Fields (yes or no)

Thank you Jake

It depends more on the nature of the data in the tables, and the
nature of the joining fields.

Enforce RI? Almost surely Yes. I don't know what the real-life logical
relationship between a record in Vitals and a record in Cemetary might
be, but I'd guess that you want to ensure that you don't make use of a
nonexistant Cemetary to bury a person (or, bury a person who never
existed). RI will prevent that.

Cascade Update? Depends on the nature of the joining field. This is
actually rather rarely useful: all it does is that if you *edit* -
change the value of - the "one" side table's linking field, that same
change will be made in all of the child table's records. If you are
linking from an Autonumber field you can't edit it anyhow so it makes
no sense to cascade updates that will never happen.

Cascade Deletes? Almost certainly not. Setting that will cause *every*
record in the Child table which matches a record in the Master table
to be automatically, irreversibly, and silently deleted whenever you
delete a main table record.

John W. Vinson[MVP]

 

[jake]

Thanks John... I can't believe one minute I'm reading your book and the
next your typing a response to one of my questions...what a great world
we live in and thank you for your help.
Jake

 

[Jeff Conrad]

in message:

Thanks John... I can't believe one minute I'm reading your book and the
next your typing a response to one of my questions...what a great world
we live in and thank you for your help.

John, have you written a book????
Or is Jake confusing you with John Viescas?

 

[jake]

If he didn't write the book, he should have... he's very good!

 

[John Vinson]

Thanks John... I can't believe one minute I'm reading your book and the
next your typing a response to one of my questions...what a great world
we live in and thank you for your help.
Jake

I don't have the attention span to write books... my esteemed
colleague and friend John Viescas has written several, and they are
most of them on my bookshelves (or my desk, getting used and thumbed
up). Glad it worked for you, and thanks for the compliment!

John W. Vinson[MVP]