> On 11/17/05, Eric E <whalesuit@xxxxxxxxx> wrote:
> >
> > What's the best way to do this? My immediate reaction is that I want a
> > partial foreign key, but perhaps this is not a good way to go about such
> > a design.
Normally I just have multiple columns with all but one NULL.
Alternatively you can make it a many-to-many relationship. So you have a
problem table and then you have a problem_product, problem_customer, and a
problem_order table.
--
greg
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
message can get through to the mailing list cleanly
