Rental database - balance entry

[Newby]

I am try to set up a database to track rental income. When I am posting cash I want to ensure the entry is balanced before it posted. I have set up a table called GL and JE batch. The idea is that I would enter cash receipt into JE batch and before posting I want check to ensure the the sum of JE batch is equal to 0 else error messsage saying batch is not in balance.

For example1:



Cash $ 500
Rent $-600
Caretaker fee $ 100
Sum $ 0 Postable

For example21:

Cash $ 500
Rent $-600
Caretaker fee
Sum $-100 Error msg batch out of balance


If there an easier way to do this I'm all ears.

Thanks in advance

Newby

[June7]

Do you have a form set up for this? Have unbound textbox in form header for the Cash amount. Enter records for the credits in detail section. Have a textbox in form footer that sums the records. Have a "Save" button with code that saves the last record then checks if the sum agrees with the cash.

[Newby]

No no no no no no and no, but you have given me some ideas. Thanks