Filemaker Pro 9 (78) Flashcards
This set entered on 5-23-14
- 22.14.1
- p 373. MANAGING THE RELATIONSHIP GRAPH. Just like the RELATIONSHIP GRAPH, the TABLE OCCURRENCE MENU NEEDS to be organized because:
you need some sort of organization to find the T.O. you need when you need it. This is easy to do when they are grouped and in some sort of alphabetical order.
- What is the method used to organize the RELATIONSHIP GRAPH and thus the TABLE OCCURRENCE MENU?
ANCHOR-BUOY TABLE OCCURRENCE GROUPS.
- With an ANCHOR-BUOY GRAPH, you’ll create only:
the TABLE OCCURRENCES you need to DISPLAY SPECIFIC DATA ON EACH LAYOUT.
- What is the ANCHOR in the ANCHOR-BUOY graph?
It is a TABLE OCCURRENCE at the left end of the TOG, and IT IS THE ONE THAT DETERMINES THE CONTEXT OF THE LAYOUT.
- What is the BUOY in the ANCHOR BUOY TOG?
The BUOYS are ALL THE OTHER T.O.s trailing along in the wake of the ANCHOR.
- When you’re building an INVOICE LAYOUT, you’ll want to display data from almost all your tables so that:
when you’re looking at any specific INVOICE RECORD, you can use the POWER of DATA TUNNELING to see the items outlined in the cards that follow (in the NEXT SETS OF CARDS)
- a. The job for which the invoice was created, from the Invoices__JOBS Table Occurrence
b. ALL TIMESLIPS related to the job (through the Invoices__JOBS Table Occurrence)
c. All TIMESLIP line items related to the TIMESLIP (through the Invoices__JOBS TO and the Invoices__TiMESLIPS TO)
d. All EXPENSES related to the job (through the Invoices __JOBS TO)
8.
e. All Expenses Line Items related to the job (Through the Invoices__JOBS TO and the Invoices__Expenses__LINE ITEMS TO)
f. The CUSTOMER who is related to the job (through the Invoices__JOBS TO).
g. All the LINE ITEMS for the INVOICE (directly from the Invoices__INVOICES TO)
h. All INVOICE PAYMENT LINE ITEMS for the invoice (through the Invoices__INVOICE PAYMENTS TO).
