How to give a formula in my issue

[sandya]

Hello friends, Can anyone help on my issue

I need some calculation formula about Cust. Disc% and CustDisc Amt fields.

Both of direct punching fields so in this case i need a formula that is if enter the percentage value in Cust.Disc% field then update automatically CustDisc Amt field. Or enter a value in CustDisc Amt field then update automatically Cust.Disc% field with each MRP and Qty wise as per screenshot values. I have attached the screenshot please find it.

Both fields are enter the values as choice wise so how to give a formula both fields?

 

[jdraw]

Please show all of your tables and relationships.

 

[sandya]

I have attached the db please find it.

Form: BillBook1

Thanks,
Sandhya