Attached is my relationships of a small database I am developing for my brother-in-law and his small auto repair shop.
He enters data each month to tally Totals on money spent on parts ( PartPurchased) and outside of his shop work (subletPurchased).
And to tally total of money received.
He also enters shop expenses.
This all needs to be able to be queried my date.
He never has need to query by customer, Yet.
This was my first data base I ever developed and it was a mess, so I am redoing it correctly this time.
The question I have is:
Are my table correct as you see them?
If I ever have a need to query by customer I think I can by using the date table. Not to sure there.
Thanks,
Dale