(no title) (original) (raw)

Oh hi, look, second post in a row....

I'm trying to do a multiplication of databinding, but not sure what exactly to google for the simplest solution...

Ideally, I would like to pull from two databases, one pulling product information, including price, then pull from another, pulling a particular discount to multiply by when it matches up with a certain code. So, if you have put in 1234 as the code, it pulls the 100.00fromtheproductdatabase,andthenmatchesthecodewith.80andmultipliesthepriceandthediscount,andthenjustspitsout100.00 from the product database, and then matches the code with .80 and multiplies the price and the discount, and then just spits out 100.00fromtheproductdatabase,andthenmatchesthecodewith.80andmultipliesthepriceandthediscount,andthenjustspitsout80.00.

At the very least, I wouldn't mind just having to do one database pull, and multiply the price by a fixed number in the databind field. It's usually the same number anyway when we do updates, but I'm just trying to future-proof it as much as possible.

Is there an easy way to do this and/or a good resource to explain how to do it? I'd like to keep it as simple as possible.