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

    Value Lists

    GrahamKeogh

      Title

      Value Lists & Look-ups

      Post

      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?

      Thanks