T tR Sep 20, 2003 #1 I need to place three field (Topic1, Topic2 and Topic3) using the same Drop Down list. Is this possible. Tessa
I need to place three field (Topic1, Topic2 and Topic3) using the same Drop Down list. Is this possible. Tessa
D Douglas J. Steele Sep 20, 2003 #2 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
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 Sep 20, 2003 #3 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
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
