[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