Filemaker Pro 9 (95)

Question 1

This set entered ON 7-26-14. 5.25.14.6 1. CREATE A NEW TABLE called INVOICE FINDER. Then go to the FIELDS TAB and:

Answer 1

create a new field, call it START DATE, and make it a DATE TYPE.

Question 2

2. Click on the OPTIONS BUTTON, and in the FIELD OPTIONS dialog box, click on;

Answer 2

the STORAGE TAB and turn on the USE GLOBAL STORAGE checkbox.

Question 3

3. Why use a GLOBAL FIELD in card #2?

Answer 3

Since this field IS NOT HOLDING DATA about an ENTITY, BUT is used to CHANGE THE RECORDS THAT DISPLAY IN A PORTAL, you need TO USE A GLOBAL FIELD.

Question 4

4. Repeat SAME STEPS to create:

Answer 4

ANOTHER GLOBAL FIELD called END DATE.

Question 5

5. In the RELATIONSHIP GRAPH, grab the INVOICE FINDER T.O. (created in step 1) and change its name to:

Answer 5

Invoice Finder_INVOICE FINDER. This NEW T.O. will become the ANCHOR in the NEW TOG.

Question 6

6. Add a new OCCURRENCE of the invoices TABLE, call it Invoice Finder__INVOICES, and a NEW OCCURRENCE of the JOBS TABLE and call it Invoice Finder__JOBS. Why do you need the new JOBS T.O.?

Answer 6

Since your PORTAL will show invoices AND the JOB ASSOCIATED with each INVOICE, you need these tables in the GROUP as well.

Question 7

7. How do you RELATE these TWO TABLES?

Answer 7

Drag the Invoice Finder__INVOICES::Job ID field onto the Invoice Finder__JOBS::Job ID field to create the RELATIONSHIP.

Question 8

8. Click the Add/Edit RELATIONSHIP BUTTON (This is just like dragging one field to another, but gives you more options up front), to:

Answer 8

OPEN the EDIT RELATIONSHIP DIALOG BOX.

Question 9

9. From the LEFT table’s pop up menu, choose:

Answer 9

Invoice Finder_INVOICE FINDER

Question 10

10. From the RIGHT table’s pop up menu, choose:

Answer 10

Invoice Finder__INVOICES

Question 11

11. CONTINUE ON NEXT CARD SET

Answer 11

EMPTY SIDE.