FM0-308 · Question #66
A FileMaker 13 solution has two tables called Company and Customer. Both tables have a number field called CompanyID. The two tables have a relationship between them formed by the condition Company…
The correct answer is D. Any time the CompanyID field on the Customer record is modified. See the full explanation below for the reasoning.
Question
A FileMaker 13 solution has two tables called Company and Customer. Both tables have a number field called CompanyID. The two tables have a relationship between them formed by the condition Company : :CompanyID = Customer: : CompanyID. Each table also has a text field called CompanyName. The CompanyName field in the Customer table is defined to Auto-enter calculated value, with the formula:
Company: : CompanyName and the option Do not replace existing value of field unchecked. Under which circumstances will the value of the CompanyName field on a Customer record be refreshed with data from the related Company record?
Options
- AAny time the Customer record is modified
- BAny time the index of the Company: : CompanyID field is rebuilt
- CAny time the related Company: : CompanyName field is modified
- DAny time the CompanyID field on the Customer record is modified
- EAny time a user chooses Refresh Window from the Records menu while viewing the Customer
How the community answered
(25 responses)- A4% (1)
- B4% (1)
- D80% (20)
- E12% (3)
Community Discussion
No community discussion yet for this question.