> On 11/17/05, Eric E <whalesuit(at)gmail(dot)com> 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