1
Q
This set entered on 5-20-14
- 17.14.4
- 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:
A
add a couple of fields so you CAN SEE THE INVOICE LINE ITEMS and ASSIGN them to the corresponding EXPENSES.
2
Q
- Adding the fields using the Expenses__LINE ITEMS Table Occurrence is just like adding any other fields, but make sure YOU ARE:
A
using the Expenses__LINE ITEMS TABLE OCCURRENCE, NOT the original LINE ITEMS TABLE.
3
Q
- You add those fields to the EXPENSE layout by dragging a new field to the layout. In the SPECIFY FIELD dialog box, choose:
A
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.
4
Q
- Choose the INVOICE ID field, because this field lets you:
A
view the INVOICE ID on which this expense was billed.
5
Q
- Add the EXPENSES::LINE ITEM ID to the layout as well because:
A
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.
6
Q
- 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:
A
the ASSOCIATED INVOICE NUMBER through the RELATIONSHIP.
