AnsweredAssumed Answered

how to have a conditional value list make look up to related fields

Question asked by hanstrager on Dec 9, 2012
Latest reply on Dec 20, 2012 by philmodjunk

Title

how to have a conditional value list make look up to related fields

Post

     I basicly have what seems to be a very easy problem, never the less it's not really working out for me...

      

     I have a small database where i have 3 tabels:

     1) product category (Fabric, leather, trims etc.)

     2) product information (name of product, size, supplier, price etc)

     3) technical overview of product

      

     so far i have made a conditional value list that filters my product based on the product category. I want choose a product based on the category and then in seperate fields show price, supplier etc. I want to do without using a portal, since im making it for a print layout...

     So far im testing with a price field, i've assigned prices to all my products, but the price only changes when i change the category it dosn't change when i chose the different products which is in the same category... what can i do..?

Outcomes