FMPro7 Viewing information from a "One" Table in a "Many" Table

This lesson requires Students.fp7 .

This exercise is based on the relationship you defined in Exercise 1 between "Students" and "Schools". Since each "Student" attends only one school at a time, this relationship is called a "Many-to-One". To view information from the "One" table "Schools" within the "Many" table "Students" does not require a portal.

1. If you do not have the file "Students" open, select File -> Open and select Students.fp7 from the list of sample files.

2. Choose View -> Layout Mode and select the layout "Student Data" from the list of available layouts above the flip book icon.

3. Click the Field Tool and holding down the mouse button, drag the Field tool onto the layout below the "School Number" field and release the mouse button. The Specify Field dialog box appears. The fields from the "Students" table appear in the list. In order to access fields from the related table "Schools", you need to choose the related table from the drop-down list at the top of the dialog box. You will now see fields from the "Schools" table. As a visual reminder that you are looking at related fields, two colons precede each field name.

4. Click "School Name". Make sure the "Create Field Label" checkbox is checked. Click "OK".

5. Add the "Dept Coordinator" field and label to the layout below the "School Name" field.

6. Add the "Dept Phone" field and label to the layout below the "Dept Coordinator" field.

7. You will now use the Object Size Palette to set the width of each of the fields you just added. Choose View -> Object Size.

8. Select the "School Name" field and set the field width to 3 inches.

9. Select the "Dept Coordinator" field and set the field width to 3 inches. Tip: To set more than one field to the same dimensions, hold the Shift key down and select as many fields as you wish. Then set the field dimensions and they will all be changed simultaneously.

10. Set the width of the "Dept Phone" field to 1.5 inches.

11. Choose View -> Browse Mode to view the related data.

If you have an RSS feed that would be of interest
to faculty and students at the College of Education
please contact Mary Harrsch.