I want to make a data-entry grid to simulate 2 columns for 1 field.

I've a Amount field and want to display 2 columns in grid i.e. Dr Amount, Cr Amount

User should be able to enter numeric value in any of the columns, and after entering data in one row, Valid routine will update the DBCR field (Logical) to indicate whether its Debit amt or credit amt..

Anybody having any ideas to do it..

TIA..