Pro-Form Quick Start 9.0 User's Guide Page 68
- Page / 82
- Table of contents
- BOOKMARKS
Rated. / 5. Based on customer reviews
Lesson 11 | Making databases relational 68
5. Release the mouse button. You see the relationship you have created.
The relationship is based on matching data in the Company field in both tables. Records are
related when data in the Company field in one table matches data in the Company field in the
other table.
6. Click OK to save this relationship.
Display data from a related record
Once you’ve defined the relationship, you can modify a layout to display data using that
relationship. Here you want to display the company address.
1. Choose Corporate Account Information from the Layout pop-up menu in the layout bar.
2. Click Edit Layout in the layout bar.
3. Using the Field tool in the status toolbar, drag a field onto the layout.
You see the Specify Field dialog box displaying the list of fields in this table.
4. Click Current Table (“Customers”) and choose the Companies table from the list.
You now see a list of the fields in the related table Companies. The colons (::) before each field
name show that these are related fields, not fields defined in the Customers table you are
currently working in. These related fields will display data from the related table.
5. Select ::Company Address.
6. Select Create label (if it’s not already selected), then click OK.
7. Repeat steps 3-6 for ::City and ::Country.
8. Move the fields if necessary, and resize the fields to display all the data they contain. When
you’re finished, the fields should look like this:
9. Click Save Layout, then Exit Layout in the layout bar to return to Browse mode.
- FileMaker 1
- Contents 3
- Lesson 1 7
- FileMaker Pro basics 7
- Database concepts 8
- Lesson 2 10
- Browsing information 10
- See a different layout 12
- Form View 14
- Table View 14
- List View 14
- Customize the status toolbar 15
- For more information 16
- Lesson 3 17
- Finding and sorting records 17
- Pie chart 18
- Choose Find Matching 18
- Number of find requests 20
- Choose range 20
- Narrow your search 21
- Sort your found set 22
- Last Name and click Move 23
- Add a new record in List View 24
- Lesson 4 25
- Click to create another field 26
- Choose Number 26
- Enter data into the database 27
- Modify data in a record 28
- Enter data in Form View 28
- Delete a record 28
- Lesson 5 30
- Customizing what you see 30
- Resize, move, and add a field 32
- Add a field 33
- Add a tab panel 34
- Display a number as currency 35
- Change text size and color 36
- Add a graphic to the layout 37
- Lesson 6 38
- Create mailing labels 39
- Create a form letter 41
- Page boundary 42
- Clear this checkbox 43
- Lesson 7 45
- Simplifying data entry 45
- Create a calculation field 47
- Test your calculation 49
- Lesson 8 51
- About scripts 52
- Assign a script to a button 53
- Lesson 9 55
- Creating and running reports 55
- Clear the checkboxes of 56
- Select Include Subtotals 59
- The report preview 59
- Clear Customer Type to 60
- 4. Click Finish 63
- Lesson 10 65
- Charting data 65
- Lesson 11 67
- Making databases relational 67
- Select this 69
- The portal displays a 70
- Lesson 12 72
- Sharing and exchanging data 72
- Opening a remote file 74
- About exchanging data 75
- About importing data 76
- Lesson 13 78
- Specify settings for 79
- Create a privilege set 80
- Lesson 14 82
- Backing up your databases 82
Related products and manuals for Treadmills Pro-Form Quick Start 9.0
Treadmills Pro-Form PFTL81910.1 User Manual
(36 pages)
(36 pages)
Treadmills Pro-Form PETL11711.0 User Manual
(36 pages)
(36 pages)
Treadmills Pro-Form ZT4 Specifications
(28 pages)
(28 pages)
Treadmills Pro-Form Power 995c User Manual
(36 pages)
(36 pages)
Treadmills Pro-Form 780 ZLT User Manual
(32 pages)
Treadmills Pro-Form 560 HR User Manual
(26 pages)
Treadmills Pro-Form ZT8 Specifications
(40 pages)
(40 pages)
Treadmills Pro-Form Quick Start 9.0 User's Guide
(270 pages)
(270 pages)
Treadmills Pro-Form 635 User Manual
(16 pages)
(16 pages)
Treadmills Pro-Form 480 CX User Manual
(36 pages)
(36 pages)
Treadmills Pro-Form 385ex User Manual
(1 pages)
(1 pages)
Treadmills Pro-Form 831.298301 User Manual
(22 pages)
(22 pages)
© 2020, manymanuals.com. All rights reserved. | 2.931 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Comments to this Manuals