1 Reply Latest reply on May 19, 2015 12:02 PM by philmodjunk

    Value Lists



      Value Lists & Look-ups


      Just wondering what is the best approach for me in the following.

      I have a 'quotation' table with a portal to a 'Line Item' table. I have an item type field which is a value list pulling from an 'item type' table which has records with the type of services offered. So design, development, printing etc

      I have separate fields in a client table which has the price rate per client for each service; so a design rate field, a development rate field, etc.

      I was wondering what is the best way to link these so that when an item type is chosen in the quotation it populates the correct rate for that specific client?