AnsweredAssumed Answered

Multiple Conditional Value Lists

Question asked by GlennButler on Jan 24, 2013
Latest reply on Jan 24, 2013 by philmodjunk

Title

Multiple Conditional Value Lists

Post

      

     Hi,
      
     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.

Screen_Shot_2013-01-24_at_1.36.15_PM.png

Outcomes