Subject Re: [IBO] Colors for IB_LookupCombo in an IB_Grid
Author Helen Borrie
At 10:29 PM 07-02-01 +1300, you wrote:

>I wonder if there needs to be a foreign key constraint between the two
>columns? The FAQ says this is required, but it is not required when the
>column names are identical.

That is wrong...although that *is* how master-detail relationships work
with the native Delphi TQuery and the IBX TIBQuery. But this is **NOT** a
master-detail relationship.

It's a thoroughly bad thing to have a FK relationship defined referencing a
low-selectivity column such as you have in a Keysource-Lookup relationship.

Please show us
(1) the SQL for the Keysource table and
(2) the entry you have for KeyLinks for the Lookup table.

>I have proven this. The GSG does not have the
>word "foreign" in it. (using Help Find). The CONTACT.GDB database also does
>not have a FKConstraint between the columns so the advice in Lars' FAQ
>article is too strong.

...and wrong...


All for Open and Open for All
InterBase Developer Initiative ยท