|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
|
|
SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today! |
|
#1
|
|||
|
|||
|
DropDown Menu - Stop duplicate values showing
I have got a drop down menu that displays everything in my "topic" field in access database. Does anyone know how I can make the values in the dropdown box single values. <br><br>Eg if you had a car colour field "Red" may come up 10 times but how can you get it to appear once in the dropdown menu?<br><br>Help would be appreciated Rob <img border="0" src="/forum/emoticons/eyes.gif" height="15" width="15" alt="eyes" />
|
|
#2
|
|||
|
|||
|
Rob,<br><br><br>did u used <br><br>"select distinct colour from tblCar" I mean did u tried using DISTINCT Keyword.<br><br>Niki
|
![]() |
| Viewing: ASP Free Forums > Database > Microsoft SQL Server > DropDown Menu - Stop duplicate values showing |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|
|
|
|