Filemaker Pro 9 (94)

Question 1

This set entered on. 7-26-14 5.25.14.5 1. p 394. CREATING THE INVOICE FINDER. To set up the new relationship, you need to use the two new GLOBAL fields created on p 376. In what table DO YOU PUT THEM?

Answer 1

Since the GLOBAL FIELDS aren’t associated with any particular table, YOU CREATE AN NEW TABLE TO HOLD THEM.

Question 2

2. You also need a new RELATIONSHIP that:

Answer 2

matches fields in the INVOICES TABLE with these GLOBAL FIELDS.

Question 3

3. This is the sort of job that benefits from its own TABLE OCCURRENCE GROUP. Call this group:

Answer 3

INVOICE FINDER

Question 4

4. To get the PORTAL to show the right INVOICES, you need:

Answer 4

a RELATIONSHIP THAT USES YOU R NEW GLOBAL FIELDS.

Question 5

5. The RULES for this relationship are a little more complicated. What are they?

Answer 5

Invoice Finder: Globals::Start Date≤Invoice Finder: Invoices::Date AND Invoice Finder:Globals::End Date≥Invoice Finder:Invoices::Date

Question 6

6. What do the RULES in card #5 say?

Answer 6

That an invoice should match if its date in ON OR AFTER (≥) the GLOBAL START DATE, and if the date is ON OR BEFORE (≤) the GLOBAL END DATE.

Question 7

7. The steps to create a new TABLE are outlined in the next set of cards.

Answer 7

This side left blank on purpose.