Why We Should Use Parent and Child Table to Make a Journal Entry Form

There are several ways to create a table for recording transaction journal. Several software developers like to make a table that contains all the required fields in a single table of the journal, some other divide the table in 2 parts: the parent table and the child table. In essence, these two types of tables will give the same results. But in the process they are different.

Create Tables in MS Access - Transaction Table

In the accounting system, transaction table is a table containing the financial events that are recorded each time a transaction occurred based on valid evidences or documents.

The process of recording in a journal is stored in the transaction table. Generally, journals of transactions that will be created consist of two tables:

1. Parent table: contains information that is global and is a summary, for example, the ID number of the journal, the journal type, journal name maker, name of the verifier/approver
2. Child table: contains information that is details such as account codes, references, debits, credits, and descriptions of the transactions.