Drop Down List - Product to Pricelist
Drop Down List - Product to Pricelist
(OP)
Hello,
Really need someones help on how to do this.
How do you create a Dropdown list that has your product listed and when you select one from the list it displays the price for that product in a box below.
Forgive me if this is so simple, i just dont know where to start.
Thanks.
Example Below in what im talking about
Productlists: Dropdown
Product1
Product2
Product3
Pricing: Product1Price
Product2Price
Product3Price
Thanks again
Really need someones help on how to do this.
How do you create a Dropdown list that has your product listed and when you select one from the list it displays the price for that product in a box below.
Forgive me if this is so simple, i just dont know where to start.
Thanks.
Example Below in what im talking about
Productlists: Dropdown
Product1
Product2
Product3
Pricing: Product1Price
Product2Price
Product3Price
Thanks again
Talk To Other Members
RE: Drop Down List - Product to Pricelist
Hope someone can help me.
RE: Drop Down List - Product to Pricelist
I would create a separate database, either as a different file or within this as a different Table.
With that, you create your Product list that contains the details (inluding price).
The file that you want those 2 things displayed would ave the product (a drop down value list that's created by the field names from your product database. That would show a drop down with the name of your products). You then create a relation between the 2 databases using your product name as the link. The Price field would just be looking to your product database price field.
RE: Drop Down List - Product to Pricelist
1-many relationship would be the cleanest.
All the best!
:--------------------------------------:
All around in my home town,
They tryin' to track me down...