[thelist] yet another database/table relationship design question

Chris Blessing webguy at mail.rit.edu
Fri Oct 18 09:54:00 CDT 2002


Indeed that was the problem.  Upon looking at the actual relationship the PK
table was Ancillaries and the FK table was Products, completely backwards.

Thanks again for the insight!

Chris Blessing
webguy at mail.rit.edu

> > Ummm.... no. If, in the quoted database design, you're doing
> > something like
> >     INSERT INTO Products(Product_Code) VALUES ('PRODUCT0001')
> > then that should work.
> >
> > It sounds like (it would be helpful to see the exact error message) that
> > you've got your foreign key the wrong way around. Product is the primary
> > key table; Ancillaries should be the foreign key table. I
> suspect that you
> > have this the other way around, or that you have created the FK between
> > Product.Product_ID and Ancillaries.Ancillary_ID by mistake.
> >

More information about the thelist mailing list