Hi, I have a small db which has my price list, I have 3 fields in it,

1) Item #
2) Item Description
3) Item Price

I want to add a 4th field which is

4) Discount Price

So when I enter the Item Price as $100, then the Discount Price should automatically show $75 (as a 25% discount). Can anyone help me with it?

Thanks for your help in advance.

Perhaps have the onchange property for the field call a JavaScript function which changes the appropriate field perhaps something like this:

function UpdateTheDiscountPrice() {
document.frmMyForm.MyDiscountPrice.value = document.frmMyForm.MyItemPrice.value * .25;
}

And here's a good JavaScript board:
http://www.codingforums.com/forumdis...p?s=&forumid=2