Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Two lookup comboboxes for a single field -- sorted differently
Tue, Aug 21 2007 2:59 AMPermanent Link

Ivan
Hello,

I have a table with two lookup fields (personal number and name) referencing another table
(employees). I have two dblookupcomboboxes side by side for these two fields. What I want
is to have the entries in these two comboboxes sorted independantly, so that the items in
the "name" combobox are ordered alphabetically, and the personal number in the other
combobox are ordered numerically. (Note that the personal number has nothing to do with
the ID). Naturally, both comboboxes select a value for a single field of the table
(ID_Employee). How can I achieve this?

Thanks in advance,
Ivan
Tue, Aug 21 2007 4:10 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ivan


1. Use two instances of the table (or two queries or 1 table and one query) reflecting the different orders
2. Use ComboBoxes not DBComboboxes and populate manually.

Roy Lambert
Image