0

Hello,

I would like to tie a dropdown list to my dataset that i have populated from my database.
however, there are repeated values in the datatable.

my table is as below...

    BMNO          CellName
    123           office
    242           office
    678           production
    290           production
    101           productiom
    890           stores
    512           Goods In
    514           Goods In
    900           Dispatch

Is there a way to add each cell name once to my dropdown list?

Thank you for looking and any help!

Iain

2
Contributors
5
Replies
6
Views
5 Years
Discussion Span
Last Post by Nichito
0

You could make the dropdown to collect the data from a dataset with a select command that selects unique records for the CellName:

SELECT UNIQUE CellName FROM Table
0

i get a syntax error with that command...

Syntax error (missing operator) in query expression 'UNIQUE ProdCell'

0

ah I used select distinct which sort of works
however, i get the first item is listed twice?

looks like this

office
officeofiice
production
stores
goods in
dispatch

any idea why it would be doing that???

0

Check the data in the cell, since it probably has an error, so it displays the row as if it was a different entry. If it recognized the data as distinct, it probably is.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.