Dynamic Conditional Values Record Picking

Hello, 

I have an app that is building a scope of work based on several variables. I currently have four tables. 

• Inventory Items
• Scope of Work
• Rooms
• Materials

Inventory Items Table holds information about materials that can be selected such as pricing, check boxes for which rooms the inventory items can be present in a project, description, units of measure, internal accounting codes, etc. 

The Scope of Work Table holds information regarding each project and can have several rooms created within it from the Rooms table. 

The Rooms Table is rather basic and mostly functions as a bridge of information to be bundled and siloed. It is important to note, on this table a "Room Type" is selected (bath, bed, living room, etc). 

The Materials Table is mainly a child of the Rooms Table, allowing for individual items from the Inventory Table to be added into individual Rooms that are built on the Room Table. 

Now we come to the issue I am having, all 600+ materials have check boxes of the list of rooms they can be present in (list attached below). I am in need of finding a way to limit the "Materials" that can be selected from the record picker on the Materials Table to the Inventory Table, to match the "Room Type" that has been selected on the Rooms Table. I have created a record picker report on the Inventory Table that I am using on the Materials Table and am also pulling the "Room Type" from the Room Table to the Materials Table. However I can not sort out a way that is dynamic enough to limit what is available in the record picker report to only items that are marked as "true" to being present in currently selected room. Each material may be present in several rooms. 

List of rooms:

Demo
Paint & Prep
General
Exterior
Entry
Living Room
Dining Room
Kitchen
Hall
Bed
Bath
Basement
Garage
Cleaning