Query filters based on table data? Can this be done

[thechazm]

Good Evening All,

Does anyone know if you can setup a query to pull in table data and use it like a not in list type of filter?

Meaning if the data was this:

1 WV 5
2 WV 6
3 NW 4
4 WV 8

And in the not in list I would put that I don't want NW so then the data would be:

1 WV 5
2 WV 6
4 WV 8

But like I said I would like the not in list to be fueled from a table and not hard coded?

I know I can achive this by writing some code to modify the query on the fly where it operates in the same manner but I was just curious if this can be done without coding being involved.

Thanks

 

[spikepl]

check the first post in this forum

 

[thechazm]

ROFL don't I feel sheepish now... Thanks