Step 1 Create a Department Maintenance Form

Step 1. Create a Department Maintenance Form

FRM035 - Maintain a Simple Database Table

In this step you will create a simple form to fetch a record from the Department file.

In the later steps, you will add insert, update and delete operations to this form to build a complete maintenance application.

1.  Create a new, basic form named iiiMntDept Database Access (where iii are your course assigned initials). If you are using iii=DEM, your component must be named DEMCOM03.

2.  Using the Repository tab, locate the DEPTAB file. Notice that the file has two fields DEPTMENT and DEPTDESC. The file is keyed on DEPTMENT.

3.  Drag and drop the DEPTMENT and DEPTDESC fields on to the form.

4.  Add a Status Bar to the form so that validation error messages can be displayed.

5.  Add a Push Button to the form.

a. Set the button Name and Caption to Fetch.

b. Create a Click event routine for the Fetch button.

6.  Your form should appear like this: