Filemaker Pro 9 (73)

Question 1

This set entered on 5-20-14

5. 17.14.2
6. p 368. If you create a new TO of the LINE ITEMS TABLE, you’re:

Answer 1

giving that table NEW MEANING in the RELATIONAL STRUCTURE of your database

Question 2

2. You can access this new TO - Expenses__LINE ITEMS- from:

Answer 2

any TABLE OCCURRENCE in the system

Question 3

3. You can access the new Expenses__LINE ITEMS TABLE OCCURRENCE from any TO in the system, in particular, you can:

Answer 3

add Expenses__LINE ITEMS details to the EXPENSES LAYOUT.

Question 4

4. You CANNOT put fields from EXPENSES on the LINE ITEMS L A Y O U T because:

Answer 4

that [Line Items] LAYOUT is attached to the LINE ITEMS TABLE OCCURRENCE, NOT the Expenses__LINE ITEMS occurrence.

Question 5

5. If you instead decide to create a NEW TABLE OCCURRENCE of the EXPENSES TABLE, then you cannot view:

Answer 5

LINE ITEM info from the EXPENSES LAYOUT, BUT YOU CAN VIEW EXPENSE INFO from the LINE ITEM LAYOUT. In this case, you’ve given expenses a new meaning (Billed Expenses, perhaps).

Question 6

6. If you want, you can create new OCCURRENCES of BOTH TABLES. If you do, you’ll be able to:

Answer 6

see EXPENSE information from a LINE ITEM, AND LINE ITEM info from an EXPENSE, but UNLESS you plan to use data that way, you’re only creating more work for yourself.

Question 7

7. The current RELATIONSHIP 
GRAPH is:
a. CUSTOMERS-One to Many-JOBS
b. EXPENSES-Many to One-JOBS
c. TIMESLIPS-Many to One-JOBS
d. INVOICES-Many to One-JOBS

Answer 7

e. LINE ITEMS-Many to One-INVOICES
f. INVOICE PAYMETS (Join Table)-Many to One-INVOICES
g. PAYMENTS-One to Many-INVOICE PAYMENTS (Join Table)