Filemaker Pro 9 (75)

Question 1

This set entered on 5-20-14

5. 17.14.4
6. To put the new Expenses__LINE ITEMS to EXPENSES relationship to work, switch to LAYOUT MODE and go to the EXPENSES layout, so that you can:

Answer 1

add a couple of fields so you CAN SEE THE INVOICE LINE ITEMS and ASSIGN them to the corresponding EXPENSES.

Question 2

2. Adding the fields using the Expenses__LINE ITEMS Table Occurrence is just like adding any other fields, but make sure YOU ARE:

Answer 2

using the Expenses__LINE ITEMS TABLE OCCURRENCE, NOT the original LINE ITEMS TABLE.

Question 3

3. You add those fields to the EXPENSE layout by dragging a new field to the layout. In the SPECIFY FIELD dialog box, choose:

Answer 3

Expenses__LINE ITEMS. The fields FROM the LINE ITEMS TABLE appear BECAUSE THIS IS AN OCCURRENCE OF THE LINE ITEMS TABLE, just like the LINE ITEMS occurrence itself.

Question 4

4. Choose the INVOICE ID field, because this field lets you:

Answer 4

view the INVOICE ID on which this expense was billed.

Question 5

5. Add the EXPENSES::LINE ITEM ID to the layout as well because:

Answer 5

This field lets you assign a Line Item from that invoice to the expense. AGAIN, make sure you pick the Expenses::Line Item ID field, NOT the Line Items::Line Item ID field.

Question 6

6. Switch to BROWSE MODE and start entering expenses. Make some EXPENSE RECORDS, and put the ID of a LINE ITEM in the LINE ITEM ID field. You now see:

Answer 6

the ASSOCIATED INVOICE NUMBER through the RELATIONSHIP.