Filemaker Pro 9 (92)

Question 1

This set entered on 7-26-14 5.25.14.2 1. ADVANCED RELATIONSHIPS. So far we’ve created simple relationships with ONE RULE and KEYS that MATCH EXACTLY. But you can create relationships that:

Answer 1

go FAR beyond those basic concepts.

Question 2

2. What’s an example of an ADVANCED RELATIONSHIP?

Answer 2

You have a table of student test scores that contains all the tests for all the kids in your school.

Question 3

3. You can view a CLASSROOM’S SCORES on a SPECIFIC TEST by making a RELATIONSHIP that:

Answer 3

MATCHES TWO KEY FIELDS: the CLASSROOM ID and the TEST ID.

Question 4

4. You can also find all the kids that are failing by:

Answer 4

matching every test score that is less than 70 points.

Question 5

5. You could do the same tasks by performing a SEARCH in your TEST SCORE table and ad some SUMMARY FIELDS to a REPORT. But YOU’RE LIMITED BY THE FACT THAT:

Answer 5

The Sub summary Parts and their fields don’t show up in BROWSE MODE, and by the need to perform the SEARCH again every time you want to see the data.

Question 6

6. With the techniques that follow, you can make this data available with:

Answer 6

just the switch of a LAYOUT or a GTRR command.