Using Arrayed Tables for Multiple Applicants

Multi-applicant forms are prime candidates for arrayed data storage. In most cases, you will need to get the same information for each applicant. For example, let’s say you have a commercial loan with four borrowers. You can use arrayed data fields for all the borrower information:

You already know how to create the above because it is really a two-column table. However, with more than one applicant, some lists can get more complex. You might need to have separate lists of data for each borrower.

Suppose, for example, we need separate lists of assets and liabilities. In the table below, you have a list of borrowers and a list of assets for each. To show you how the fields work together, we will show you how to define the fields in each column. We will assume by now that you could create the above layout with no problem, so we’ll confine our discussion to defining the data field properties.