1
Q
This card set entered on 5-23-14
- 22.14.2
- How do you decipher the format: Invoices__JOBS?
A
a. The INVOICE part tells you what LAYOUT the Table Occurrence is used on
b. The part in ALL CAPS tells you the SOURCE TABLE for the Table Occurrence.
2
Q
- Therefore all Table Occurrences with the INVOICE prefix are meant to:
A
do INVOICE LAYOUT DISPLAY WORK or INVOICE DATA MANAGEMENT: the PREFIX INDICATES THE CONTEXT.
3
Q
- So if you wanted to display CUSTOMER DATA on the INVOICE LAYOUT (Which has the CONTEXT of the Invoices__INVOICE TO), you’d look for:
A
The Invoice__CUSTOMER TO and PLACE A FIELD FROM IT on your Layout.
4
Q
- If you don’t NEED to see a lot of data, you can use a simpler TOG. If you only need to find a CUSTOMER RECORD, CUSTOMER DETAILS, JOBS PERFORMED FOR THAT CUSTOMER, and ALL INVOICES for those JOBS, the TOG would be:
A
IN THIS EXAMPLE, THE ARROW (-->) WILL INDICATE A RELATIONSHIP. Customers\_\_CUSTOMERS --> Customers\_\_JOBS --> Customer\_\_INVOICES.
5
Q
- If you also wanted to see the INDIVIDUAL LINE ITEMS for an INVOICE, you would add:
A
an OCCURRENCE of the LINE ITEMS table, name it, and then put a field form the NEW Table Occurrence on the CUSTOMER LAYOUT.
