AnsweredAssumed Answered

Value Lists

Question asked by GrahamKeogh on May 19, 2015
Latest reply on May 19, 2015 by philmodjunk


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?