hi,
i useto drag the field at mylist directly from mytable,
i don't have any idea about distinct.
thanks
>SELECT DISTINCT billno from yourtable
>
>>hi all,
>>i have a table with field billno evry billno have many items as under
>>

>>billno itemno
>>1         1
>>1         2
>>1         3
>>2         1
>>2         2
>>2         3
>>3         1
>>3         2
>>3         3
>>.         .
>>.         .
>>
>>

>>i need help to see at mylist billno as 1,2,3,4...just one time
>>thanks