Ask about the problem of non-repeating list of combo box values?

the5ers

I put a combo box in the form, and set a field related to the data value in the generator (the material name of the material library), but the same name in the list box is in the list box, how to let them only One so that users have a clearer choice? Thanks a lot :-)

170385215

select dist material name into cursor ltmp from material library

Then bind the field material name in this temporary table ltmp

170385215

INIT event of the form

select dist material name into cursor ltmp from material library
THIS.COMBO1.ROWSOURCE = NULL
THIS.COMBO1.ROWSOURCETYPE = 6
THIS.COMBO1.ROWSOURCE = 'ltmp. Material name'
THIS.COMBO1.DISPLAYCOUNT = IIF (RECCOUNT ('ltmp') <= 20, RECCOUNT ('ltmp'), 20)