I'm having second thoughts about the way I'm handling Lookup Combo's in my
app's, and I was just wanting to get some recommendations of whether I
should change my style or not.

At the moment, I have an ID and a Description field for all lookup combo
items. The ID field is a GUID, hidden from the user, and the Description
field, is the field that displays in the lookup combo, even though the value
stored is the ID.

The problem I have is that when the user 'Looks up' an item, I only want it
to show a list of Currently available items. However, I need the Lookup
Combo to display the relevant Description for all items in the lookup table,
regardless of whether they are active at the moment, or no longer active.
This allows a user to see the Description of an item if they go back to
older records.

At present, I have a TDBISamQuery for the lookup source which shows ALL the
items, and I use the ondropdown, oncloseup events of a lookup combo to set a
filter to view only active/current items, and clear a filter whenever the
user performs this operation.

Is this the most effective / efficient way of performing this, or should I
be doing something else?

Thanks & Regards

Adam.

Your approach is what I do.  Works well for me.

Walter

"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in message
news:A2B54CC3-387E-42D0-8B4E-2CF56D7EC80C@news.elevatesoft.com...
> I'm having second thoughts about the way I'm handling Lookup Combo's in my
> app's, and I was just wanting to get some recommendations of whether I
> should change my style or not.
>
> At the moment, I have an ID and a Description field for all lookup combo
> items. The ID field is a GUID, hidden from the user, and the Description
> field, is the field that displays in the lookup combo, even though the
> value
> stored is the ID.
>
> The problem I have is that when the user 'Looks up' an item, I only want
> it
> to show a list of Currently available items. However, I need the Lookup
> Combo to display the relevant Description for all items in the lookup
> table,
> regardless of whether they are active at the moment, or no longer active.
> This allows a user to see the Description of an item if they go back to
> older records.
>
> At present, I have a TDBISamQuery for the lookup source which shows ALL
> the
> items, and I use the ondropdown, oncloseup events of a lookup combo to set
> a
> filter to view only active/current items, and clear a filter whenever the
> user performs this operation.
>
> Is this the most effective / efficient way of performing this, or should I
> be doing something else?
>
> Thanks & Regards
>
> Adam.
>
>

> Your approach is what I do.  Works well for me.

Thanks Walter, I guess I just needed some confirmation.

Cheers

Adam.