Guido,

I was thinking the same. For example I have a customer with COUNTRY =
10, that numeric value is referencing a record in the COUNTRY table with the
rest of the information about that country, the name and still other things.
I think I'm in the same confusion like you

Nico Callewaert

-----Oorspronkelijk bericht-----
Van: guido.klapperich@... [mailto:guido.klapperich@...]
Verzonden: dinsdag 3 april 2001 15:03
Aan: IBObjects@yahoogroups.com
Onderwerp: Re: [IBO] Foreign Key

> 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.


Yahoo! Groups Sponsor

Click Here to Find Software Faster


Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]