>I have alot of fields of the same type and I need to set filt to for each one of them simultaneously. Example: set filt to state1="paid" .or. state2="paid" .or. state3="paid" .or. state4="paid".......state30 ="paid" etc down to over 30 states.
>
>How can I get around this limitation?
Could you:
select keyfield, state1+state2+staten as allstates from sourcetable into cursor statespaid
set filter to "paid" $ allstates
index on keyfield tag keyfield
select myorgtable
set relation to keyfield into statespaid
count all for !eof("statespaid")
--Todd Sherman
-Wake Up! Smell the Coffee!