Filemaker Pro 9 (91)

Question 1

This set entered on 7-30-14
5.25.14.1

1. p. 389. To finish formatting the LOOKUPS, add field for:

Answer 1

a. Company Name
b. First Name
c. Last Name

Question 2

2. To save time formatting the last three fields, you:

Answer 2

duplicate the STREET ADDRESS field, CHANGE ITS NAME, and then just change the field FROM WHICH IT LOOKS UP.

Question 3

3. p. 390. TRIGGERING A LOOKUP. Normally, you trigger a LOOKUP whenever you change:

Answer 3

the DATA IN THE KEY FIELD ON WHICH THE RELATIONSHIP IS BASED.

Question 4

4. Sometimes you have reason to cause a LOOKUP to occur without changing the KEY FIELD. Say you mistyped a customer’s address in the CUSTOMER’S LAYOUT, so all the invoices are incorrect too.

Answer 4

You can correct the address in the CUSTOMER’S TABLE, but that DOES NOT correct the invoices, since the address field there is a LOOKUP.

Question 5

5. So what resource do you use when you wish to correct an address in the CUSTOMERS TABLE and ALL THE RELATED INVOICES?

Answer 5

Use the RELOOK UP FIELD CONTENTS command

Question 6

6. How do you activate the RELOOKUP FIELD CONTENTS command?

Answer 6

a. Click inside the field that NORMALLY TRIGGERS the LOOKUP
b. Choose RECORDS–>RELOOKUP FIELD CONTENTS
c. Click OK on the dialog box that pops up.