Removing a value in one feild if a value is entered into another?

[quillpro]

For ease of explanation, let say I am creating a checkbook register. I have two fields "Credits" and "Debits".

What I want to happen is if I already entered a value in the "Credits" field and I then put a value in the "Debits" field the value in "Credits" would be removed or vise versa.

I have tried many attempts using auto enters and calculations but to no luck. Any direction would be most appreciated.

Thanks

Edited July 21, 2006 by Guest

[Søren Dyhr]

You're almost there:

http://www.newcenturydata.com/downloads/checkbox_control.zip

--sd

[Raybaudi]

Hi

the AutoEnter/Replace calc for debits is:

Let(

fieldName = Get ( ActiveFieldName ) ;

Case(

fieldName = "debits" ; debits ;

not IsEmpty ( credits ) ;""

)

)

the AutoEnter/Replace calc for credits is:

Let(

fieldName = Get ( ActiveFieldName ) ;

Case(

fieldName = "credits" ; credits ;

not IsEmpty ( debits ) ;""

)

)

BTW: if you wish to show a zero and not an empty field simply substitute the line:

[color:red]not IsEmpty ( credits ) ;"" with:

[color:blue]credits ≥ 0 ; 0

and the line:

[color:red]not IsEmpty ( debits ) ;"" with:

[color:blue]debits ≥ 0 ; 0

[quillpro]

Thank you that work perfectly. I think I tried almost that very thing but I used it as an if statement.

Edited July 21, 2006 by Guest