Multiple calculations from 1 data entry

[dazed-confused]

First post here: after 3 days of reading internet forums and watching videos I surrender!

I'm working on a db where i have a value thats sell price for an item.

what I would like to happen is to be able to input the price in sell price

and then have sell price + sales tax + credit card processing fee

and cash sell + sales tax

both appear based off sell price + freight..

the closest I've come was being able to add freight and sale price to display..

any help is greatly appreciated..

thanks

dazed, confused.

here is the attached DB

zip file.

invendb.zip

[comment]

See if this helps:

PriceIncl.zip

[Aussie John]

Just a little point but wouldn't the calc for the credit card fee be a percent of the price inc sales tax and not a sum of the sales tax and CC card fee. ie a compound percentage.

[dazed-confused]

Thanks For the Help

is there a simple way of merging the FP7 file into my existing? I tried copy/paste but the relations are all messed up.

wish there was a good tutorial for this on utube :hmm: