Multiple fields in table using same Drop Down list

T

tR

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

Tessa
 
D

Douglas J. Steele

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
 
B

BJ Freeman

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
 
Top