Filemaker Pro 9 (82)

Question 1

This card set entered 5-23-14
5.22.14.5

1. p 377. These are the steps to create the TOG for the ASSIGN LINE ITEMS TO EXPENSES layout. Go to the RELATIONSHIP GRAPH, and click on:

Answer 1

the ADD TABLE OCCURRENCE button. The SPECIFY TABLE window pops open, and you select the EXPENSES table.

Question 2

2. Why did you create the EXPENSES table first?

Answer 2

When you create the LAYOUT later, it will have the CONTEXT of the EXPENSES table, so it is the ANCHOR in the ANCHOR-BUOY TOG, and thus makes sense to create it first.

Question 3

3. In the “NAME OF TABLE OCCURRENCE,” type:

Answer 3

Assign Expenses__

EXPENSES, and click OK

Question 4

4. When you name the new table Assign Expenses__EXPENSES, what does the Assign Expenses part mean?

Answer 4

it says that THIS new Table Occurrence was created especially for the PROCESS OF ASSIGNING EXPENSES.

Question 5

5. In the Assign Expenses__EXPENSES TO name, what is the meaning of the “EXPENSES” part?

Answer 5

The EXPENSES (ALL CAPS) part INDICATES the TO’s SOURCE IS THE EXPENSES TABLE.

Question 6

6. Now you add the remaining Tos. What are they?

Answer 6

a. Assign Expenses__INVOICES
b. Assign Expenses__LINE ITEMS
c. Assign Expenses__Invoices__LINE ITEMS
d. Assign Expenses__JOBS

Question 7

7. Now that you have all the new Table Occurrences, you:

Answer 7

add the RELATIONSHIPS

Question 8

8. Create a Relationship between Assign Expenses__EXPENSES and Assign Expenses__LINE ITEMS using_______________as KEYS.

Answer 8

the LINE ITEM ID field

Question 9

9. Create another relationship between Assign Expenses__EXPENSES and Assign Expenses__INVOICES, using ______________as KEYS

Answer 9

GLOBAL INVOICE ID and INVOICE ID

Question 10

10. Connect the remaining RELATIONSHIPS using:

Answer 10

the matching KEYS. Global Fields DO NOT apply to the remaining two relationships.