Combo Box List

[Beany]

ive got a combobox with a list of sites....

i click on a site and it brings up details of it.................

the problem that i have is: in my table i have one site with different details,

site: Liverpool, 8 highfield avenue etc etc
site: Liverpool, 11 High Street etc etc

so in the combobox list it only shows one Liverpool.... i want it to show both liverpool sites.... how can i get the combobox to show duplicates???

 

[ColinEssex]

You need another column in the Combo to show something other than Liverpool - say the first line of address?

Col

 

[Beany]

i can possibly show Liverpool1, Liverpool 2.... which is the easy way out...

isnt there a way of showing duplicates?

 

[ColinEssex]

change the query behind the Combo so it doesn't 'GroupBy'

Col

 

[ColinEssex]

But how will you know which is the correct one for selection?

Col

 

[Beany]

true.... (and i did think of that)

but it would have been good to know...... increase my knowledge a little bit more!