>>>in my example I have a dbf fields office,bpac,method & others where as there are 6 or so different values for office repeatedly. After I set the filter & index and browse, NO RECORDs show! As below
>>>
>>>mbpac='691999'
>>>use e:dbf
>>>set filt to 'CR_C' $ method .and. mbpac= allt(bpac)
>>>brow fiel method,bpac,office *ok so far
>>>inde on office to e:z uniq
>>>brow fiel method,bpac,office * no records show!
>>>Sounds crazy?
>>
>>Timothy, save yourself a bunch of confusion and just use SQL to get these records.
>>
>>SELE dbf
>>INDEX ON Office TAG Office
>>SELE * FROM dbf ;
>>WHERE "CR_C"$method AND mbPac = ALLTRIM(bpac) ;
>>GROUP BY Office ;
>>INTO CURSOR Whatever
>>
>>BTW, if DBF is really the name of your table, I highly recommend changing it to something that is not a keyword.
>
>no, dbf is just my example name. Sounds like a lot more statments are needed using sql eh? Also another file needs to be created to get the job done too. I have not used sql cmds up to this point.
>-TB

Well, Tim- it's coming up on time for you to learn SQL. You might be surprised at how easy some of the things you try to do are when you use the right tool.