>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

Mohammed Tore and I said:
You Have Table with rows:
billno itemno
>>>1 1
>>>1 2
>>>1 3
>>>2 1
>>>2 2
>>>2 3
>>>3 1
>>>3 2
>>>3 3

You can write in your code:

SELECT DISTINCT billno FROM YoutTable INTO MyCursor
Select MyCursor
Browse NORMAL

or what you need