It contains every product in my store (PC). The informatin contained in this database is displayed on the web as products. One feature of my online store is a PC builder (the usual drop down and select). The way it is setup is you have Processors for example
optID: The item # is the primary key (auto defined, sequencial)
optGroup - item group belongs in
optName - the products name
optPriceDiff - normally set up as say a PIV 2.2 is 100 the PIV 2.3 is 110 so the differnce is 10. I am entering in retail cost in this field. So the price diff is 110 as the base price of the PC is 0 instead of say $750
OptWeightDiff - is the difference in weight of the different choices (a 19" monitor weighs more than a 15" for shipping purposes)
What I would like to do is be able to enter in my cost for each product and have it auto update to the optPriceDiff. The main catch is that I can't add any extra fields or it will screw up my coding for my webpages. I have tried hiding them but it doesn't work.
Is there a way that I can run a query that will pull the prices let me enter in my cost and then have it update that table with the retail price (for exmaple it says P4 2.2 I enter in 80 as my cost and it does 80/.8 for a price of 100.
Is this possible? Could I also change the optName at the same time?
What I think might be a good move for you is to visit http://www.ASP101.com and find out the lowdown on useing ASP to do the math for you. It's nice and gental on new users and I found it a great place to start.