This set entered on 5-20-14
5-17-14-3
1. A new field was created to make a new relationship between the EXPENSES TABLE OCCURRENCE and the LINE ITEMS TABLE OCCURRENCE. What is in this field?
Expenses::LINE ITEM ID
- You’ll create a NEW TABLE OCCURRENCE for the LINE ITEMS table because:
you want to ACCESS LINE ITEM DETAILS while you are on the EXPENSES layout.
- In general, which table gets the NEW TABLE OCCURRENCE?
In general, it is the information that you are using in a new way that GETS THE NEW TABLE OCCURRENCE, the LINE ITEMS table, in this case.
- So you have a LINE ITEMS table occurrence connected to EXPENSES through INVOICES and JOBS. You also now have a new LINE ITEMS table occurrence called Expenses__LINE ITEMS. Although you only have ONE Line Items Table, YOU ARE TELLING FILEMAKER IT HAS TWO MEANINGS:
a. A LINE ITEM ON AN INVOICE
b. A LINE ITEM that bills for an EXPENSE.
- How do you create a new TABLE OCCURRENCE?
a. MANAGE DATABASE dialog box, click ADD TABLE OCCURRENCE button
b. Select the LINE ITEMS table from the list, and name it Expenses__LINE ITEMS
c. Click OK
- Why do you name the new TABLE OCCURRENCE: Expenses__LINE ITEMS?
you want a descriptive name so you can pick it out of a lineup later.
- The SPECIFY TABLE dialog box asks you to name the NEW TABLE OCCURRENCE. When you name a new TABLE OCCURRENCE, the GOAL is to:
help you remember the SOURCE TABLE for the new TABLE OCCURRENCE.
- Why was the new TABLE OCCURRENCE named Expense__LINE ITEMS?
a. The “EXPENSES” part of the name tells you why you made the new TO- to help tie in INVOICE LINE ITEMS to the PROPER EXPENSE RECORDS
b. “LINE ITEMS” is in ALL CAPS, so you can remember that the new TO comes from the LINE ITEMS table. Use whatever naming scheme you want, but USE IT CONSISTENTLY.
- Now you drag the Expenses::LINE ITEM ID to the Expenses__LINE ITEMS::Line Item ID field. What type of RELATIONSHIP is this?
ONE TO ONE. ONE EXPENSE IS on ONE LINE ITEM.
