ComboBox returns bound ID rather than lookup value

[cmarziale]

The first table named SITES defines locations

ID_SITE is an auto number field and primary key
CLLI is the name of the location I need to lookup

The second table named SwitchPathInv which connects two locations together

SwitchPathID is an AutoNumber field and primary key
ASiteID is a number field with a relationship to ID_SITE which represents one end of the path. This field has a lookup of its own to display the CLLI of a site rather than the ID_SITE in the table def.

SELECT SITES.CLLI, SITES.ID_SITE FROM SITES ORDER BY SITES.CLLI; BoundColumn=2 ColumnCount=1

ZSiteID represents the other end of the path and also has a relationship to ID_SITE. This has the same lookup.



A third table named RadioInv inventories equipment at sites. Radio (equipment) on this table need to have a SwitchPathID assigned to individual equipment records. When I create a combo box for control source SwitchPathID, I'm using the following SQL:

SELECT [SwitchPathInv].SwitchPathID, [SwitchPathInv].ASiteID, [SwitchPathInv].ZSiteID FROM SwitchPathInv;

Now when I look at the datasheet for the query, I see the correct information, that is the A and Z CLLI is showing for each SwitchPathID. However, in the combo box, I'm only seeing the ID_SITES.

[June7]

Sounds like you need to set up a multi-column combobox, review http://datapigtechnologies.com/flash...combobox3.html