In a set with an parent table and a one-to-many linked child table, a browse on a form is a very good way to display the child records linked to a given parent record. If the child records are simple, a browse is also a good way to enter new child records, but there are several good reasons why you may want to enter new child records via a form rather than the browse. If there are a number of fields in the child table to fill in, the horizontal display of a browse will need to be scrolled to the right and left, and not all fields can be viewed at once. Also, a form in Alpha Five version 5, provides many more events than a browse, hence giving the developer finer control over the users movement during data entry. This tutorial demonstrates one method of using a form to enter new child records in a set. I will use the AlphaSports database that ships with Alpha Five version 5 to demonstrate this technique. .

Click here to view the demo on adding child records via a dialog form.