OK, here we go
First let's draw the relationships. I keep is simple with words to draw.
Area < Employees <Requests < Request Line Items > Materials
Area < Materials
So that says that one area has many employees and each employee is able to make many requests and each request has many Request line items on it. The Request line Items is the join table between requests and materials.
The next line says that One Area has Many Materials.
I think that this is easy. Just lookup the Area down from Area to Employees, to Requests to Request Line items and include that Area field onto the Request Line Items form for the form sees it.
The you will have a field for [Related Material] on the Request Line items form. Set that field to be a Conditional Drop Down "CDD" (slang) by checking the box that says that the selection choices are conditional where the [Area lookup from Employee] is equal the the [Area] of the Material.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
