Lookup Wizard

[enc]

A quick query. Just want to know if this is possible.

When you create a lookup wizard you select the criteria for which the lookup is to work with and have the possibility of setting the Bound Column, Column Heads, Column Count and Column Width properties respectively. This however only displays these viewing perspectives when the lookup is clicked on.

Is it possible to display two fields in the lookup without having to click the item and look at the pulldown menu.


I'm not sure if I'm making myself clear. I hope somebody makes sense with it. Ask if you're unsure what I mean. Thanks.

 

[dcx693]

Is it possible to display two fields in the lookup without having to click the item and look at the pulldown menu.

There is no "built-in" method, but there are workarounds. What you present and what you show in the combo box does not need to be what is stored. You can display column 1 and store column 2. Just concatenate all the data you want to show into a column and present that column to your users, store whichever column you want. Then when the combo box is closed, they'll still see all the concatenated data.

 

[enc]

Nice ideas. I'll look into them. Thanks.