Can a combo list display 2 field values?

JustMaybe

Registered User.
Local time
Today, 19:55
Joined
Oct 18, 2002
Messages
134
Just really wanted to knoe if this is a feasible option!...

I want a drop down list that currently contains all my products to also contain all my services!...is this possible??
 
You could can have more than one column for the combo, so that could be worth a try if the services and products linked.
 
It is possible to show more columns in a combo box.

What is the relation between your product and your services?
What are you trying to do?
 
If your goal is a combo box that lists "things we sell", the following might help...

If "products" and "services" are stored in separate tables, then you should be able to create a union query that pulls in the necessary values from each (say, the ID and description fields).

Then, you would set the source of your combo box to that union query.
 

Users who are viewing this thread

Back
Top Bottom