[thelist] database help
rudy
r937 at interlog.com
Tue Nov 19 12:24:01 CST 2002
> Now, I have to allow my user to manage the categories. If the user
> decides he doesn't want red in the categories anymore he deletes it.
> Now of course we have trouble, since some of the food items were
> pointing to red.
your choices are to disallow the delete, or to delete all the related
records
automatically as well
most people choose to disallow, forcing the user to delete the related
items individually, before the category can be deleted
perhaps my relational integrity article may help --
RI to the Rescue!!
http://evolt.org/article/foo/18/13276/index.html
rudy
More information about the thelist
mailing list