I am looking to use dynamic views but what I need may be out of its range of functionality.
I have a table with 30000 rows and I was hoping I could filter the data data via SQL instead of bringing it all back and filtering - which I tried and will not work.
I have a stored procedure and first wanted to use a filter option(s) as the parameters. is this possible?
I can also create a view but the where clause would have to be done prior to bringing back the data. is that possible?
Any ideas on how to do this using views or forms somehow?
~Steve