Multiple Conditional Value Lists
I run a small tree business and I'm trying to create estimates that have line items linked to each tree we perform work on.
1) In an ESTIMATE layout I want to select a client.
2) In an ESTIMATE layout I want to select a property from a value list related to the client. (So far, so good)
3) In an ESTIMATE layout with a portal based on SERVICELINES, on each row I want to select a tree from a value list related to the property previously selected.
When I add a TO based on TREES and create a relationship to SERVICELINES, my drop down list on the ESTIMATES layout (inside a portal based on SERVICELINES) gives me the list of all the trees associated with that client and not just the trees related to that particular property.
Any help would be appreciated.