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!