OK, I know this should be easy but I've been trying to get this to work for days and need some help.
I a main BO called Project. From the project I create a BO called Sections. Also from the Project I create a BO called Inspections (where we inspect the Sections)
I use shortcuts to carry the Project Name and the company office name to each of the Sections and Inspections BO's.
Now, the user picks a project form and clicks on create a new inspection. I have a relationship called InspectionSections established in the Inspection form so the user can pick the sections they are inspecting. This all works fine.
My problem is that I want to filter the sections choices to only show the sections that match the Project Name and Office Name on the inspection Object. I've tried every filter I can think of on the settings button for the add items button but cannot get it to filter.
I hope this makes sense?
