After appending a record from table A into B, how can we continue to allow data entry on Table B?

[June7]

All values can be entered as positive and then use IIf() in Sum to identify those that should be negative.

Sum(Price * IIf([TxnType]="Checkout", -1, 1))