how to have a conditional value list make look up to related fields
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..?