Linking two tables in a pull down list

Hi,

Problem:
How do I create a form that contains a pull down list for the source
and destination (reference the table definition shown below) that shows
the name of the item not the id number? The way I am doing it is
through a query which only allows one name field. So I thought to do
it through the pull down list, but it only displays the id. The pull
down list will display both but upon selection just the id is
displayed. I need the name to be displayed?

The following tabl is used:
Relationship Id - Key
Source Id - links to x table
Definitive Item Id - links to y table
Destination Id - links to x table

x Table:
id
name

Anyone have any suggestions on how to do this.

re: Linking two tables in a pull down list

If I understand you right, you're trying to show two columns in a combo
box control, and you've got a SQL statement populating the row source.

If that's the case, you'll need to set the Column Count property in the
control's Format tab to 2, and establish the Column Widths
appropriately based on the width of the columns. If your underlying ID
column is the first in your query, for example, the your Bound Column
property in the Data tab should also be set to 1.