FIlemaker Pro 9 (90)

Question 1

This set entered on 7-30-14
5.23.14.5

1. p 387. CREATING LOOKUPS. How do you create a LOOKUP?

Answer 1

You define the field normally but add an AUTO ENTER Option called LOOKED UP VALUE. You can also add a LOOK UP to an EXISTING FIELD.

Question 2

2. THE FOLLOWING ENTRIES OUTLINE THE STEPS TO CREATING A LOOKUP. You will designate the Customer’s ADDRESS as a LOOKUP. You start by:

Answer 2

2. THE FOLLOWING ENTRIES OUTLINE THE STEPS TO CREATING A LOOKUP. You will designate the Customer’s ADDRESS as a LOOKUP. You start by:

Question 3

3. What happens when you choose LOOKED UP VALUE?

Answer 3

The LOOKUP FOR FIELD ‘STREET ADDRESS” pops up.

Question 4

4. What are the FIRST TWO options to choose in the LOOKUP FOR FIELD “STREET ADDRESS”?

Answer 4

a. Starting With Table

b. Lookup From Related Table.

Question 5

5. What option should you choose in the STARTING WITH TABLE pop up menu?

Answer 5

Think about what the CONTEXT is. You’re defining a field in the INVOICES TABLE, so that’s the field’s CONTEXT. In this case, the CONTEXT is the INVOICES table

Question 6

6. What choice should you make in the LOOKUP FROM RELATED TABLE pop up menu?

Answer 6

In this case, you choose the CUSTOMERS table, because that’s where the ADDRESS field resides.

Question 7

7. As soon as you choose CUSTOMERS in the LOOKUP FROM RELATED TABLE pop up menu, what happens?

Answer 7

the COPY VALUE FROM FIELD list (this is the third option in the LOOKUP FOR FIELD “STREET ADDRESS” dialog box) is populated with ALL THE FIELDS in the CUSTOMERS TABLE.

Question 8

8. You choose the ADDRESS field AND turn OFF the “DON’T COPY CONTENTS IF EMPTY.” What does this do?

Answer 8

When you turn off “DON’T COPY CONTENTS IF EMPTY,” FileMaker COPIES THE EMPTY VALUE, wiping out data in the LOOKUP field. If you turn this option ON instead, FileMaker leaves the LOOKUP field UNTOUCHED- ITS VALUE BEFORE THE LOOKUP REMAINS IN PLACE.

Question 9

9. The LAST option in the LOOKUP FOR FIELD “STREET ADDRESS” is “IF NO EXACT MATCH, THEN:” What does this do?

Answer 9

It gives the FOUR options on what to show if there is no exact match a. DO NOT COPY

b. COPY NEXT LOWER VALUE
c. COPY NEXT HIGHER VALUE
d. USE.

Question 10

10. Which of the four options under IF NO EXACT MATCH, THEN should you choose?

Answer 10

USE, and leave the associated text box empty. I there is no customer record, the address field should be blank.

Question 11

11. What if under IF NO EXACT MATCH, THEN, you choose the DO NOT COPY option?

Answer 11

Then, any existing address, for a different customer, perhaps, is left in the field.