Hi!

Read Anns reply to "Getting garbage info from the database" (two
messages before your question), where she advices to use triggers
rather than foreign keys.

HTH,
Set

> Will these foreign keys automatically generate indexes for these
> fields. If yes, these indexes are low selectivity - lots of
> duplicates.
>
> I always heard from the forum that low selectivity will slow down
> the performance of the table.
>
> How to resolve or maybe I should not enforce the foreign keys.