lookup wizard

[dafdek]

hello,



I have created to tables.
one is a list of shops and has 2 fields: ShopNum, which is the key fields and of type AutoNumber, and ShopName of type text.
the second table also has a field of Shop. I want to choose the shop from a box in the field (through lookup wizard) but i want that the ShopName would appear in the box but the value in the field would be actually the shop number (both from the first table).

how do i do this? that one field would appear in the box but the other field would be the actual input...

thanks for your help!

[June7]

Create multi-column combobox. Review http://datapigtechnologies.com/flash...combobox3.html