THIS IS CRAZY! Why do I need the filter off? It does work with the filter off but that defeats the purpose doesn't it?


>Timothy,
>
>The VFP help says that the unique clause "specifies that only the first record encountered with a particular index key value is included in an .IDX file or a .CDX tag." Try your example without the filter. When you browse you should see one record per office. If none of those records meets your filter condition, that would explain why no records appear when you index UNIQUE and apply the filter.
>
>>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?