> No, don't define them formally as Foreign keys. You will get 6 relationships with low selectivity indexes and it will kill performance.
>
> Only use the FOREIGN constraint for master-detail or parent-child (tree) relationships. Hand-code the cascade triggers for lookup relationships such as those you mention.
>

Hi Helen

I thought the relationships between customers and the six tables are master-detail relationships.


Guido.