Kayleigh
Member
- Local time
- Today, 09:41
- Joined
- Sep 24, 2020
- Messages
- 706
Hi there
I am designing a complicated accounting database to manage transactions of various types in a company.
The primary table is obviously tblTransaction. We have identified the fields involved in every transaction (payee, recipient, amount, date etc).
My question is for payee, recipient and other similar fields - should all this data be located in one table named contacts (with use of lookup) or several tables for each type of payee (individual or business)? Also what data do I use to refer to the company itself?
Examples of transactions can be a staff payout from company, or a company paying to another company, or a client payment - all these transactions are closely linked as the money from one contributes directly to another (e.g. a client payment is allocated to a staff payout).
I would appreciate if anyone can shed light on this complexity. (This is only a start...)
I am designing a complicated accounting database to manage transactions of various types in a company.
The primary table is obviously tblTransaction. We have identified the fields involved in every transaction (payee, recipient, amount, date etc).
My question is for payee, recipient and other similar fields - should all this data be located in one table named contacts (with use of lookup) or several tables for each type of payee (individual or business)? Also what data do I use to refer to the company itself?
Examples of transactions can be a staff payout from company, or a company paying to another company, or a client payment - all these transactions are closely linked as the money from one contributes directly to another (e.g. a client payment is allocated to a staff payout).
I would appreciate if anyone can shed light on this complexity. (This is only a start...)