Filemaker Pro 9 06

Question 1

1. p 105. ADVANCED FIELD OPTIONS. What are the CREATION values?
   See fig 3-9

Answer 1

When a record is first CREATED, fm can record the DATE, TIME, OR TIMESTAMP at the MOMENT OF CREATION.

Question 2

2. Why would you want to use a CREATION VALUE?

See fig 3-8

Answer 2

To keep track of the DATE you first added each record, so you can tell how long you’ve been working with someone. You can use this information in FIND mode to seek new customers, old customers, customers you met on a tuesday, etc.

Question 3

3. When would you turn on the PROHIBIT MODIFICATION OF VALUE DURING DATA ENTRY option?
   Keep in mind that the Auto Enter options are for each individual field.
   See fig 3-8

Answer 3

An example is when you have a CREATION VALUE specified that should never change.

Question 4

4. How do you keep track of when you last changed the data?

Answer 4

AUTO ENTER–>MODIFICATION

Question 5

5. Why would you want to use the AUTO ENTER–>MODIFICATION?

Answer 5

Say you want to adjust an INTEREST RATE in you db, you can tell how long ago the change occurred.

Question 6

6. When do the MODIFICATION SETTINGS affect the value of the field?

Answer 6

AFTER you create the record. If you don’t select the PROHIBIT MODIFICATION OF VALUE DURING DATA ENTRY, the MODIFICATION setting will override whatever you type in your MODIFICATION TIMESTAMP field, since the TIMESTAMP occurs when you commit the record.

Question 7

7. Why are you able to use PROHIBIT MODIFICATION OF VALUE DURING DATA ENTRY on a MODIFICATION FIELD?

Answer 7

FM’s AUTO ENTER mechanism IS NOT CONSIDERED DATA ENTRY.

Question 8

8. When else can records change outside of data entry?

Answer 8

When you are importing records or setting fields via a script.

Question 9

9. What are the MODIFICATION settings?

Answer 9

This setting keeps track of when a record was changed