Hi There all,
I am trying to create a sort of payment tracker database as part of my app. I am running into difficulty as a transaction needs to either be a debit to a client (they owe you money) or a credit (you owe them money) which needs to either show as an addition of X ammount or subtraction of X amount towards the client and need help doing so. Any ideas how best to do that on a database?