I am trying to make register like Quicken for accounts.

I have got the calculations right. Now i want that user should enter only in one of the fields(Debit or Deposit),Eg- if user enters the value in deposit and again user is entering the value in the Debit field the previous field should get clear and vice versa

Thanks

I would like to see this too, because the clearance by the autoenter are likely to be just the event triggering for the reverse process - fields are processed one by one in a certain order - the creation order, the circularity forces both fields to their endstates - empty!

But there might be a tweak to this:

http://edoshin.skeletonkey.com/2006/06/linked_fields.html#more

--sd

Edited March 6, 200817 yr by Guest

Here's an answer I don't recommend. This reminds me of a gadget I've used: an entry in fieldA causes a response in fieldB. Likewise an entry in fieldB causes a response in FieldA. This requires at least three fields. This usually works in one direction and not the other because of reasons Soren gave. So stack a calculation field on top of the side that's not working - and, there are other variations to make this work smooth, but...

That said, for your purpose, please DON'T have any mechanism whereby a content in one critical field deletes the content of another. You can have them mutually exclusive where one field stays empty if the other has content. That's easy with autoenters. But try to make the layout so if the cat runs over the keyboard you're not screwed.

Also consider the terms: the opposite of debit is credit - the opposite of deposit is withdraw. That reminds me of Gibson guitars which for over 50 years have had a label on the pickup selector switch: RHYTHM / TREBLE (Although actually those terms do equate only in the fact that neither equates to pickup selection.).