Subject Re: [IBO] IB_LookupCombo question
Author Helen Borrie
At 11:39 AM 30-04-01 +0200, you wrote:
>I was playing with native IBO components for a while, especially with
>My problem is:
>I have a table for documents contains two fields CONSIGNEE and NOTIFY that
>will get values from Customer table (CUSTOMER_ID is the field that will
>provide values). Do I have to create separate datasets and datasources for
>each LookupCombo or there is other way to achieve this (like certains
>settings in KeyDescLinks).

If both Consignee and Notify are referred to by the *same* customer_id and both point to one and only one customer row, then you can use one dataset and one datasource. If the consignee might refer to one customer and the notify to another, then you need two sets.

If the first case applies, then you possibly have some undesirable redundancy in the documents table.


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