Filemaker Pro 9 (79)

Question 1

This card set entered on 5-23-14

5. 22.14.2
6. How do you decipher the format: Invoices__JOBS?

Answer 1

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.

Question 2

2. Therefore all Table Occurrences with the INVOICE prefix are meant to:

Answer 2

do INVOICE LAYOUT DISPLAY WORK or INVOICE DATA MANAGEMENT: the PREFIX INDICATES THE CONTEXT.

Question 3

3. 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:

Answer 3

The Invoice__CUSTOMER TO and PLACE A FIELD FROM IT on your Layout.

Question 4

4. 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:

Answer 4

IN THIS EXAMPLE, THE ARROW (-->) WILL INDICATE A RELATIONSHIP.             Customers\_\_CUSTOMERS
-->
Customers\_\_JOBS
-->
Customer\_\_INVOICES.

Question 5

5. If you also wanted to see the INDIVIDUAL LINE ITEMS for an INVOICE, you would add:

Answer 5

an OCCURRENCE of the LINE ITEMS table, name it, and then put a field form the NEW Table Occurrence on the CUSTOMER LAYOUT.