General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Best way to display subsets of data
Hi all,
I have a number of tables that has information about applications (people applying to receive benefits from a program).
I will be using a view (or mulitple views) to display the data in a grid. I want to give my users the options of displaying:
- all applications
- completed applications
- incomplete applications
What is the best way to handle this? once the size of the data gets large, Filter's are not efficient, right? I could have 3 different views and change the RecordSource for each.
I've thought about somehow having a view parameter that will collect the entries required, but don't quite know how to handle this. If the main table has a field, lCompleted, obviously, I can query for all completed applications or all uncompleted applications, w/something like:
... WHERE lCompleted = ?Thisform.lShowCompleted
But how to expand that to query for all applications? this might be totally obvious, but I can't see it.
Thanks for any input. J
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only