How do I make a field calculate vat?

[digitaljunkie]

I have a ex VAT Field that I need to add VAT onto.

How do I make my inc VAT field calculate 17.5% onto the price?

Also can I make bot fields dynamic so if I enter info into one field it recalculates the other field?

i.e if i enter the ex_vat price, the inc_vat field auto calculates or vice versa if enter the inc_vat price, the ex_vat will auto calculate?

[John Mark Osborne]

Have you tried the auto-enter calculation option? You'll find it in Define Database by double-clicking on a field. Make sure to uncheck the option to "do not replace existing value (if any)" so the auto-enter occurs anytime referenced fields are modified.

[Raybaudi]

Hi

both fields must be number with option of AutoEnter/Replace a calculation.

The calc for the field "ex_vat" is:

Case(

Get ( ActiveFieldName ) = "ex_vat" ; ex_vat ;

Round ( inc_vat / 1.175 ; 2 )

)

The calc for the field "inc_vat" is:

Case(

Get ( ActiveFieldName ) = "inc_vat" ; inc_vat ;

Round ( ex_vat * 1.175 ; 2 )

)

[digitaljunkie]

Thats awesome thanks guys.

P.S

John just wanted to say I really like your training courses, have learn't loads has made me want look into Developer Certification.