By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,495 Members | 1,209 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,495 IT Pros & Developers. It's quick & easy.

child rows without parent?

P: n/a
Ty
Question:
If the Division number changes in 1 table, it is suppose to
automatically change in the other tables. If it don't change, what is
the problem?

Response:
My professors response to my database problem/question:
It will if you have the relationship created correctly, turn on
referential integrity, and then cascade update action.

But you will have difficulties doing this as you have child rows
without parent rows which violates referential integrity. You have to
either fix the data to enable this constraint.
--------

I need a Visual. I have "child rows" without "parent rows".

Is there a problem with my tables like AUTH_ID?

AUTH_ID table
SECTY_SYS_CD
AUTH_ID_XTRA_KEY

I can't attach my database. If you send me your email address, I will
email the database so you can have a visual.

Use my hotmail, please. Same as the yahoo listed name except it is
athotmail dot com

Thanks...
Nov 22 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.