Project Filter

[JuniorWoodchuck24]

I'm trying to setup a Filter that once a project is selected it Filters all the items that don't associate with that project out of tables. So when the user pulls up reports and add items to these tables they can only view items with associated project number.

 

[JuniorWoodchuck24]

How system is supossed to work:

1. User logs in
2. User selects a project which to work on (once project selected add filter)
3. User add items to table or views reports needed.
4. User can change project at anytime. (Re-Filter if project changed)

All tables/reports/forms have been completed just curious how to add a global filter based on selection.

Project Selection:
A form with a subform that allows a user to pick a project number.
The subform is a datasheet form that is viewed like a table.