|  | 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
  Navigation: [Reply to this message] |