Posted by Usenet on 06/05/07 12:25

In article <1181019367.152432.299980@m36g2000hse.googlegroups.com>,
MadDiver wrote:
> I need to create an application that handles several product types/

You *can* set up your "reference" table so that it not only has a
foreign key of the index into the other table, but also names that
"other" table.

I don't think this falls within the normally expected use of the term
"relational database", but can certainly work, and needn't be slow, and
may be a tidier solution than trying to "rationalise" widely varying
types of data, such as the ones you're describing.

Mark

[Back to original message]