Filemaker Pro 9 (89)

Question 1

This set entered on 7-30-14
5.23.14.4

1. p. 386. EMPTY LOOKUPS. If FileMaker tries to find a RELATED RECORD to LOOK UP data from and can’t find one, then;

Answer 1

it just leaves the LOOKUP FIELD alone.

Question 2

2. When configuring a LOOKUP, you have a GROUP of RADIO BUTTONS under the “IF NO EXACT MATCH, THEN” option. What are they?

Answer 2

a. Do not copy
b. Copy Next Lower Value
c. Copy Next Higher Value
d. Use

Question 3

3. What does the DO NOT COPY option do?

Answer 3

It leaves the field alone, it does nothing.

Question 4

4. What does the COPY NEXT LOWER VALUE do?

Answer 4

This option looks at the closest LOWER Related Record. If you were looking for price information based on quantity, and the customer orders 38 units but you only have pricing for 30 or 40, this option chooses 30.

Question 5

5. COPY NEXT HIGHER VALUE

Answer 5

Works just like COPY NEXT LOWER VALUE, but copies the value form the NEXT HIGHER related record.

Question 6

6. What does the USE option do?

Answer 6

It lets you specify any value you want to substitute for a MISSING RELATED VALUE. If you are LOOKING UP customer age information and don’t have an age for the person, you tell FileMaker to use “N/A” instead.