Filemaker Pro 9 (111)

Question 1

This set entered on 8-43-14
7.29.14.1

1. What is the one serious limitation to calculations?

Answer 1

You can’t CHANGE their values.

Question 2

2. What is the solution to NOT being able to change the value of a calculation?

Answer 2

AUTO ENTER CALCULATIONS

Question 3

3. Where do you enter an AUTO ENTER CALCULATION?

Answer 3

Since it is an AUTO ENTER option, you would choose it in the AUTO ENTER page of the “Options for Field” dialog box.

Question 4

4. What is the benefit of entering the calculation into the Auto Enter section of the Options for Field?

Answer 4

The AUTO ENTER calc automatically fills in a field’s value, but LEAVES IT CHANGEABLE.

Question 5

5. When you enter a calc in the Calculated Value box, you’re NOT creating a calculation field, you are:

Answer 5

specifying the calculation to be used to determine the Auto Enter value.

Question 6

6. Auto Enter Calculation fields don’t act exactly like other calc fields. If a DUE DATE is based on an INVOICE DATE, and the INVOICE DATE changes, then:

Answer 6

the DUE DATE does not update to reflect the change, IT KEEPS ITS ORIGINAL VALUE.

Question 7

7. Once an Auto Enter calculation field gets a value, the calculation changes every time:

Answer 7

NEVER. The calc acts only when the field is empty.

Question 8

8. How do you modify the Auto Enter calc so that the calc changes every time the field is updated (like a normal calc)?

Answer 8

TURN OFF the “Do not replace existing value of field (if any)” checkbox in the Field Options Dialog Box.

Question 9

9. When would you want to turn off the “Do not replace existing value of field (if any)” checkbox?

Answer 9

You would choose this if, say, you want the Due Date to change every time you update the Invoice Date.