Filemaker Pro 9 (84)

Question 1

This set entered on 5-25-14
5.22.14.7

1. p 379. BUILDING A GLOBAL FIELD LAYOUT. Now that you’ve finished the new TOG and hooked up its relationships, you’re ready to:

Answer 1

create the ASSIGN LINE ITEMS TO EXPENSE Layout. WITH THE GRAPH DEFINED, THIS PROCESS IS SURPRISINGLY SIMPLE.

Question 2

2. How do you build the ASSIGN LINE ITEMS TO EXPENSE layout?

Answer 2

Create a NEW, BLANK layout based on the Assign Expenses__EXPENSES Table Occurrence and call it ASSIGN LINE ITEMS TO EXPENSES.

Question 3

3. The SECOND step for creating the ASSIGN LINE ITEMS TO EXPENSES Layout is:

Answer 3

Add the fields to the layout:

a. Assign Expenses__EXPENSES::Expense
b. Assign Expenses__EXPENSES::Global Invoice ID
c. Assign Expenses__EXPENSES:: Line Item ID
d. Assign Expenses__JOB::Name
e. Assign Expenses__LINE ITEMS:: Description

Question 4

4. Remember that this Layout is associated with the Assign Expenses__EXPENSES TO, so when you choose the fields for the layout, select:

Answer 4

the CURRENT TABLE from the top of the pop up menu in the SPECIFY FIELD dialog box.

Question 5

5. By definition, a GLOBAL FIELD HAS THE SAME VALUE IN ALL ITS TABLE’S RECORDS, so changing the data in a GLOBAL FIELD:

Answer 5

has NO EFFECT on any of your “REAL” data for those records.

Question 6

6. When your GLOBAL FIELD is used in a relationship, and you change the value IN THE GLOBAL FIELD;

Answer 6

the RELATIONSHIP CHANGES and SO DO THE RECORDS THAT ARE RELATED TO YOUR CURRENT RECORD.

Question 7

7. You use the technique from Card #6 to create a:

Answer 7

VALUE LIST that is based on the GLOBAL RELATIONSHIP between your NEW EXPENSES TO and the NEW INVOICE TO.

Question 8

8. When the GLOBAL RELATIONSHIP changes, FileMaker :

Answer 8

TUNNELS in the new TOG from EXPENSES to INVOICES to LINE ITEMS to get the LINE ITEM that’s RELATED THROUGH THE VALUE in your GLOBAL.