Subject Re: [IBO] 2 parent table 1 lookup table
Author Helen Borrie
At 08:59 AM 19/06/2003 +0000, you wrote:
>2 parent table 1 lookup table
>
>Is it advisable for 2 parent table to share with 1 lookup table?

Yes, but not simultaneously. When the FocusedControl changes, set the
Lookup's Keysource, KeyLinks and KeyDescFields to nil, then assign the
properties to the new datasource/lookup column/description column.

You can do this is in a generic procedure that is defined in your
datamodule and called (with the appropriate arguments) from whatever form
event suits the work flow.

Helen