Database question, please help me

[mulu]

Good Day

I wonder if someone could plz assist me with general table design. I need to create a database which manages cash received for petrol as well as a running loan. Eg, "John" receives R1000.00 from the company which is distributed amoung the staff for petrol - this needs to be recorded - and totalled per staff member. This I can do fine. HOwever, sometimes John may run short on petrol money to distribute, so he "loans" the company the money, ie R500.00 - So there also needs to be a calculation on how much he has loaned and how much we have paid back to him for refund for the loan. I cant seem to get it right, i think the problem in mine is due to the fact that "John" also receives cash for petrol, which would then not deduct from his loan, but it is a loan repayment?

Which tables should I use? I have tried
tblReceipts - for money received - either from the company or from John
tblPayments - cash paid from johns personal cash or from the companies cash to staff for petrol
tblStaff - listing staff who receive petrol, and also having a record for "Company" for when the company pays for the petrol


I hope I have explained this right,

thank you
I hope this is making sense

 

[mcalex]

I'd give tblPetrolMoney and tblLoanMoney a go.

Treat the Loan and Petrol allocations as different things, and only add or subtract them when you get to presenting data

hth
mcalex