Re: FK -> non PK - bad design?

>> Bernard, seems to me that just the fact that users may want to
change
the name of a service plan is reason enough for a system generated ID/PK. <

Look up how to use ON UPDATE CASCADE clauses in your DRI. This lets the system handle all of that stuff automatically, so it is faster, safer and the scheam is portable without the application code that was updating the service plans. Received on Sat Apr 12 2003 - 19:24:54 CDT