Product table changable pricing

[yankeer0se]

Hi...Hope I am putting this in the right category.

 

I need to set different pricing for each product in my product table.  For example, each product as a different price depending on the location it is sold.  The end user would have to be able to update these prices without changing any prior records.

 

I am a little stumped regarding how to set this up.  Any information to lead me in the right direction would be greatly appreciated.  Thanks!

[KaosMaker]

It seems like what you need is to create two new tables. One for Locations, and one for Prices. The Prices table will be related to Products and Locations. After that, you will probably need to set up a new layout: a Location layout that will allow the user to browse through all the Prices attached to that Location (with Product information also appearing in each portal row). Also, you will need to add a portal to your Product detail layout, so you can see ALL the Prices over the various Locations for that given Product.

[yankeer0se]

Thank you for your reply!  I havent had a chance to try this out yet.  My concern is maintaining the old data when prices are updated.   How do i protect the old data? 

 

Thanks