Modifying the Journal Entry Form

In the previous posting, you have known already, how to create journal entry form using Form Wizard. But the result is a rough form of Journal Entry. We should reformat and add additional function in it. Now open form frmOpenTransactionJournalParent in design view, as depicted below:

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 a Form with Sub Form Using Form Wizard

Creating a form with a sub form in MS Access is best applied to the table that have the one-to-many relationship with another table. The objective is to eliminate redundancy in one or more fields in a table.

In general, tables that will be the form is a parent table, while the table to be used as a sub form is a child table that is relevant to the parent table. For example, forms invoices, bills, purchase orders, and various other forms that have a number of details of more than one item. Of the tables we have created, table tblOpenTransactionJournalParent will become a form with table tblOpenTransactionJournalChild that will become its sub form; table tblPermTransactionJournalParent and tblPermTransactionJournalChild are as well.