Dropdown list shows multiple entries...How do i get it to show one only? (1 Viewer)

[Bobp3114]

My database has a field "Town" as part of the address of each customer. Each town (say Brisbane) can have many customers, so when i use a combo box to select a town I get multiple instances of each town. How do i get it to show only one instance of each town?

Thanks in advance
Bob

 

[arnelgp]

use a Total Query as your combo's Rowsource:

SELECT Town From yourTable GROUP BY Town;

 

[June7]

Or

SELECT DISTINCT Town FROM yourTable ORDER BY Town;

Or

Have a Towns table and use that as combobox source. Save TownID into record.