Filemaker Pro 9 (83)

Question 1

This card set entered on 5.25.14
5.22.14.6

1. What are the Tos for the ASSIGN LINE ITEMS TO EXPENSES TOG?

Answer 1

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

Question 2

2. What are the RELATIONSHIPS between the ASSIGN LINE ITEMS TO EXPENSES TOG?

Answer 2

a. Assign Expenses__EXPENSES::Line Item ID -MANY TO ONE - Assign Expenses__LINE ITEMS::Line Item ID
b. Assign Expenses__EXPENSES::Global Invoice ID - GLOBAL TO ONE - Assign Expenses__INVOICES::Invoice ID CONTINUED ON CARD #3

Question 3

3.

c. Assign Expenses__INVOICES::Invoice ID - ONE TO MANY - Assign Expenses__Invoices__LINE ITEMS::Invoice ID

Answer 3

d. Assign Expenses__INVOICES::Job ID - MANY TO ONE - Assign Expenses__JOBS::Job ID

Question 4

4. With the Relationships in place, when someone puts an INVOICE ID in the GLOBAL INVOICE ID field, it instantly matches:

Answer 4

ONE INVOICE RECORD.

Question 5

5. So you’ve put an INVOICE ID in the GLOBAL INVOICE ID field, MATCHED one INVOICE RECORD. Now you can:

Answer 5

show fields from the Assign Expenses__INVOICE TO on the LAYOUT, AND see data from the INVOICE you need to use TO ASSIGN EXPENSES.

Question 6

6. You use the other relationships to:

Answer 6

show the INVOICES LINE ITEMS and the JOB’S NAME.