By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,903 Members | 2,042 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,903 IT Pros & Developers. It's quick & easy.

Linking two tables in a pull down list

P: n/a
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.

Aug 10 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Aug 10 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.