Defining Database Schema Flashcards
What are five of the auto-entry options available for fields?
a. A calculation
b. Record-creation data
c. Record-modification data
d. A serial number
e. The value from the same field of the last active record
f. A static piece of data
g. A looked-up value
The auto-entry field options for a calculated value include a checkbox that says “Do not replace the existing value (if any).” How does unchecking this box change the field’s behavior?
When you uncheck the “Do not replace the existing value (if any)” checkbox, data in the field will be overwritten when one of the fields referenced in the calculation is modified.
- What is an index for a field?
An index is a sorted list of the unique words or values in a field. Indexes are used in finds and relationships.
Describe the two indexes available in FileMaker Pro 18 Advanced.
Value indexes
i. Can be created for text, number, date, time, timestamp fields, as well as stored calculation fields
that return these data types.
ii. Used for relating records and searches in these kinds of fields
b. Word Indexes
i. Only created for text fields and stored calculation fields that return text.
ii. A list of the unique words in a field.
iii. Used in searches.
Are there field types that cannot be indexed?
Container fields, summary fields, any field with global storage, and unstored calculations cannot be indexed.
What methods of setting a field with data are not considered data-entry for the purposes of field-level validation?
a. Replacing field contents
b. Importing records
c. Setting a field during a script
List the order in which the following actions occur:
a. A field is exited
b. A field’s value is changed
c. The value is saved
d. The value is validated
a. A field’s value is changed
b. The value is validated
c. The value is saved
d. The field is exited
A hosted FileMaker file contains a container field that is stored globally, and it holds the company’s logo. This field is placed on all report layouts. In a preferences table, the developer inserts the logo into the container field. A user reports that the logo is not on any of the reports. What caused this? How can it be fixed?
A field with global storage retains the last value set when the file was closed on a local computer, and global storage is unique to each user of the file.
The developer has two options. He can remove the file from FileMaker Server, insert the logo into the container field, close the file, and host it again. Or, he can store the logo in a container field with regular storage and write a script that runs when the file is opened that inserts the logo into the container field with global storage.
A custom app contains tables for Teachers and Classes. A teacher teaches many classes. How would you set up the data structure—the Relationships Graph and any additional tables—to show all the classes a teacher teaches?
To show all the classes a teacher teaches, a join table, possibly called “Schedule” is needed. A record in this table represents the association of a teacher with a class.
In a FileMaker file, there is a table called ContactMethods. The table occurrence Students_ContactsMethods is related to the Students table occurrence, as shown below.
A developer wants to add a calculated field in the ContactsMethods table that stores the last name of the related Student. When setting up the calculation, she discovers the Students table occurrence is not related.
What would she need to do to have access to fields from the Students table?
The developer needs to change the context from which this calculation will evaluate. That is done at the top of the calculation dialog.
Changing the context to the Students_ContactMethods table occurrence will allow the developer to create this calculation field.
Does each table in a file need to have a table occurrence on the Relationships Graph?
No. You can delete any table occurrence.
