FILEMAKER Set 1

1.

A table in a FileMaker 13 solution has a text field CompanyName. The following field validation options are set for this field:
Validate data in this field only during data entry
Allow user to override during data entry
Require not empty
Display custom message if validation fails
A user imports a set of records into this table. Some records have no value in the CompanyName field. What will occur?

All of the records will be imported, No error message will be displayed. The user will see the custom error message, but the import will continue if the user overrides the error. All records with a value for CompanyName will be imported. The user will see the specified custom message. All records with a value for CompanyName will be imported. The user will see an error dialog from the FileMaker Pro application stating that some records couldnot be imported due to errors, along with a count of those records.

2.

A new solution is created with Iwo tables, Client and Contracts. The only modification made on the Relationships Graph is to establish a relationship between them which is set to delete related records in Contracts when a record in Client is deleted. What happens when the Client table occurrence is deleted from the Relationships Graph?

Since it is the only occurrence of the Client table on the graph, it cannot be deleted. Any records in the Contracts table that were related to matching Client records are deleted. The formula in the calculation field Name Full (defined as Name First & " & Name Last) will be broken. Any records in the Contracts table that were related to matching Client records will have values in the Client ID field deleted.

3.

Which statement is true about the Filter Portal Records feature in FileMaker Pro 13?

The portal filter formula must refer to at least one field in the immediately related table. The feature requires one or more additional relationships to be added to the Relationships Graph. The portal filter formula may not refer to any globally stored fields, summary fields, or unstored calculation fields. There can be one unique filter formula applied for each portal state (Normal State, In Focus, Hover, or Pressed). Aggregate functions (e.g., Sum, Count) based on the portal's relationship will not be affected by the portal's filter formula.

FILEMAKER Set 1

Congratulations

COMPANY

Products

OTHERS

Partner

FILEMAKER Set 1

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner