DbLookupComboBox duplicate values
Hi guys,
When I click on the component, it shows the duplicate records.
Anyone have an idea how to solve it?
When I click on the component, it shows the duplicate records.
Anyone have an idea how to solve it?
Comments
One thing to try, in your dataset for the dialog box, use SELECT DISTINCT....
Rick Brodzinsky
Yes, the KeyFiled is unique (primary key on table).
SELECT DISTINCT ocurrs the same problem...
After click raise error "Reader has no more rows"
OK, distinct KeyField -- but are the ListFields unique? Is there the same info in ListField for two different keys? Can you show the data in your lookup dataset?
See attached image ...
Already tried. It's the same thing.