Review data fields in the borrower add/edit form; Decide which fields to rename

Open the BORROWERS table and review all data fields. Do you want to store additional information in one of the extra data fields (CUSTOM1-CUSTOM9)? Or, maybe there is a regular data field that you do not plan to use?

For example, there are CUSTOM1 and ADDRESS1 data fields on the first data entry page. Therefore, we will rename them to GRADE and TEACHER in the Options window.

Rename data fields in Options/Maintenance/Change Field Names

Open the Change Field Names window.

Open the Change Field Names window. Select database. Select CUSTOM1, now enter GRADE, to finish click Update. Next, please do the same modifications with ADDRESS1, and rename it to TEACHER.

Review new field names in the borrower add/edit form

You can review new changes in the borrower Add/Edit data form.

The TEACHER data field is a regular text type. It would be practical to change the field to the drop-down box type. You can do it in the Options window.

Modify "regular text" to "drop-down box" type

In the Dropdown Lists window, select BORROWERS; check the box in front of the TEACHER. Next, choose the dropdown type, and Auto-Add. You can enter the whole list of teachers into the Dropdown List text box. Click Close to save changes.

Note: you can review or edit the dropdown list values directly in text files. In this case, the file's name is BORROWER_7.txt (you can find this file in your installation folder; C:/handy_lib/data/db/ folder).

You can review new changes in the borrower Add/Edit data form.

How can you record student's teacher or grade in the loan transactions table?

Question:

Answer: