Referential integrity

From: Andreas Moroder <Andreas.moroder_at_[nospam>
Date: Thu, 01 Jun 2006 07:51:29 +0200
Message-ID: <e5m2kr$ml4$1@news.dtag.de>

Hello,

i have a big table with 25 fields that should be checked for their contents. Because I also need the description of this values I should build 25 table and activate referential integrity.

When I go on this way I will end with hundreds of very small tables.

Is there another way to guarantee referential integrity ?

I tried with functional indices on one single lookup table, but they can not be used a foreign key.

Bye
Andreas Received on Thu Jun 01 2006 - 00:51:29 CDT