>In regards to multiple filters...I have a table that can be added to (it only contains one field), and it needs to be used as the source for filtering. This table contains account numbers.
>
>How can I manipulate Foxpro into using the conditions of that table? For example...manually I code as:
>
>set filter to between(date, ldstart, ldend) and account <> 100 ;
>and account <> 150 and account <> 500 and account <> 100600
>
>You get the picture. Any suggestions on how i can get around this? Thanks!
Assuming that you've index on AccountNumber in your AccountList table,
SET ORDER TO AccountNumber IN AccountList
SELECT mytable
SET RELATION TO AccountNumber INTO AccountList
SET FILTER TO FOUND("AccountList")
--sb--