Multiple fields in table using same Drop Down list

  • Thread starter Thread starter tR
  • Start date Start date
T

tR

I need to place three field (Topic1, Topic2 and Topic3)
using the same Drop Down list. Is this possible.

Tessa
 
Sounds as though your database hasn't been properly normalized if you've got
that situation.

While you're waiting to correct the design, though, you could always create
a UNION query that forms the source of the drop down. Something like:

SELECT Topic1 FROM MyTable
UNION
SELECT Topic2 FROM MyTable
UNION
SELECT Topic3 FROM MyTable
 
yes
in the dropdown properties
Column Count = 3
Column Heads = (yes/no) depending on your taste
Column widths = 1";.5";1" note: you can use different spacing this
is just an example
Bound Columns =1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Parameter Query 1
Parameter Query, Multiple fields 3
Access 2007 - Table A lookup values based on Table B 1
How do I show more "Or" tabs when applying filter? 1
Delete attribute from XML document using XPathNodeIterator 6
Drop Down List Position on Form 2
filtering one drop down to another drop down 5
Automatically enter values in fields in a table 1

Back
Top