Filemaker Pro 9 (60)

Question 1

This set entered on 5-16-14
5.3.14.4

1. p 339 RELATIONAL DATABASES. What is the MOST IMPORTANT thing to understand when using a MULTITABLE DATABASE?

Answer 1

That EACH LAYOUT SEES THE ENTIRE DATABASE FROM A DIFFERENT PERSPECTIVE (AKA CONTEXT)

Question 2

2. A LAYOUT IS ATTACHED TO AN OCCURRENCE ON THE GRAPH, and that is how it sees the world. THIS MEANS WHEN YOU’RE LOOKING AT A RECORD on the CUSTOMER’S LAYOUT, you’re seeing:

Answer 2

a CUSTOMER. If you want to see PAYMENTS, you’ll need to switch to the PAYMENTS LAYOUT.

Question 3

3. If you do a FIND in the PEOPLE LAYOUT (say, all the people from Indiana), and you switch layouts, then return to the PEOPLE LAYOUT, you see:

Answer 3

The same FOUND SET, and you will have returned to the same record you were in when you left.

Question 4

4. What does FileMaker do with FOUND SETS when you leave the LAYOUT?

Answer 4

It remembers ONE FOUND SET FOR EACH TABLE OCCURRENCE.

Question 5

5. Can you have more than one LAYOUT attached to the SAME TABLE OCCURRENCE?

Answer 5

YES

Question 6

6. What if you do a FIND on a LAYOUT that shares a TABLE OCCURRENCE WITH SEVERAL OTHER LAYOUTS?

Answer 6

the FOUND SET and CURRENT RECORD are ASSOCIATED WITH THE TABLE OCCURRENCES, so ALL THE ASSOCIATED LAYOUTS ARE AFFECTED.

Question 7

7. What if you want MORE THAN ONE FOUND SET or CURRENT RECORD from the same TABLE OCCURRENCE?

Answer 7

Use MULTIPLE WINDOWS.

Question 8

8. What if you want to see TWO KINDS OF RECORDS SIDE BY SIDE?

Answer 8

Create a new window.