Calculation between two fileds

[Hardworker]

I am a beginner in FM with no real database background and have search this forum but found no answer to my problem.

I have Invoice table with Discount field (in %) and Discount amount field. How do I set those fields, that I could enter discount and calculate Discount Amount, or I can enter Discount amount and Discount is calculated. I would like to have both options available to me. Also, I would like to enter Discount number in % (let say 10 for 10%) no 0.1.

Thank's in advance

[aaa]

Hi, Hardwork! In attachment when you change percent calculates Discount_Amount and when you change Amount calculates Percent. Inconvience is, that when you click at one of field the second comes to empty.

You can use AutoEnter options too, but i can't resolve All problems at this way.

aaa.zip

[SlimJim]

If you go the Auto-enter route then you will find the following post helpful

http://www.fmforums.com/forum/showtopic.php?tid/169064/

[Hardworker]

Thank you guys a lot . I think I will go with aaa solution. It looks fairly simple for a novice like me.