1
Q
This set entered on 5-16-14
5.3.14.4
- p 339 RELATIONAL DATABASES. What is the MOST IMPORTANT thing to understand when using a MULTITABLE DATABASE?
A
That EACH LAYOUT SEES THE ENTIRE DATABASE FROM A DIFFERENT PERSPECTIVE (AKA CONTEXT)
2
Q
- 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:
A
a CUSTOMER. If you want to see PAYMENTS, you’ll need to switch to the PAYMENTS LAYOUT.
3
Q
- 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:
A
The same FOUND SET, and you will have returned to the same record you were in when you left.
4
Q
- What does FileMaker do with FOUND SETS when you leave the LAYOUT?
A
It remembers ONE FOUND SET FOR EACH TABLE OCCURRENCE.
5
Q
- Can you have more than one LAYOUT attached to the SAME TABLE OCCURRENCE?
A
YES
6
Q
- What if you do a FIND on a LAYOUT that shares a TABLE OCCURRENCE WITH SEVERAL OTHER LAYOUTS?
A
the FOUND SET and CURRENT RECORD are ASSOCIATED WITH THE TABLE OCCURRENCES, so ALL THE ASSOCIATED LAYOUTS ARE AFFECTED.
7
Q
- What if you want MORE THAN ONE FOUND SET or CURRENT RECORD from the same TABLE OCCURRENCE?
A
Use MULTIPLE WINDOWS.
8
Q
- What if you want to see TWO KINDS OF RECORDS SIDE BY SIDE?
A
Create a new window.
