fat controller
Slightly round the bend..
- Local time
- Today, 04:41
- Joined
- Apr 14, 2011
- Messages
- 758
I have a combo box which is used to select records that meet a specific criteria - there may be more than one record that matches this criteria, and I want all of those records to be selected. The field that sets the criteria is called BulletinNumber.
This works perfectly well, however the dropdown is showing multiple rows of the same number - so if there are three records that have a BulletinNumber of 850.1, the number 850.1 will appear three times in the drop down list.
I was thinking that using the Min function in the SQL for the combo's query would have made it return each number only once, but that isn't working, hence me seeking your help once again
EDIT - Fixed it. I should have put the Min function on the PK field.
This works perfectly well, however the dropdown is showing multiple rows of the same number - so if there are three records that have a BulletinNumber of 850.1, the number 850.1 will appear three times in the drop down list.
I was thinking that using the Min function in the SQL for the combo's query would have made it return each number only once, but that isn't working, hence me seeking your help once again
EDIT - Fixed it. I should have put the Min function on the PK field.
Last edited: