>Hi,
>
>I use SET FILTER TO mclass=class and then open a browse window to browse the data for "class" only. But some of the data like Student Class, may appear twice or more depends on the numbers of record.
>
>So, is there any way to keep the same "class" to appear twice or more?
>I want each of them to be listed only once.
>
>Gan
I don't know how to do this wit BROWSE or SET FILTER, but it is easy with SQL:
SELECT MyField1, MyField2 FROM MyTable GROUP BY MyField1
will only show one record for each value of myfield1. To only shoq one record for each unique combination of MyField1 and MyField1, use
GROUP BY MyField1, MyField2
Erik Moore
Clientelligence