Multiple fields in table using same Drop Down list

[tR]

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

Tessa

 

[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

 

[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