Click the Exhibit button.
You want to build a FileMaker Pro 8 database that models family relationships. One person may have many children. One person may also have many "parents" (including biological parents, guardians, step-parents, etc.).
You want to build the system in such a way that a single layout showing information about a person can also display two portals, one showing the names of all of the current person's children (if any) and the other showing the names of all of the current person's parents (if known).
Assume that personal names exist in only one table. There are no lookup fields or calculation fields in any tables, and there are no scripts in the file.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?
Which two statements are true regarding the use of plug-ins? (Choose two.)
Which three text functions are case sensitive? (Choose three.)
Given a FileMaker Pro 8 database containing these two scripts::
Script A:
Perform Script ["Script B" ; Parameter: 3]
Show Custom Dialog [Get (ScriptResult)]
Script B:
Set Variable [$x; Value:Get (ScriptParameter)]
Loop
Set Variable [$result ; Value: $result + $x]
Set Variable [$x ; Value: $x - 1]
Exit Loop If [$x = 0]
End Loop
Exit Script [Result: $result]
If a user runs Script A, what value will be displayed in the custom dialog?
In the Fields tab of the Define Database dialog in FileMaker Pro 8, which two are valid field types? (Choose two.)
Given a custom function created in FileMaker Pro 8 Advanced called "MyFunction" with a single parameter "Number" defined as:
If (
Number = 0 ;
Number ;
Number & ", " & MyFunction ( Number - 1 )
)
What is the result of MyFunction ( -3 )?
When manually importing data into a field that has a validation rule in FileMaker Pro 8, which statement is true?
What are three valid sources for directly importing records into FileMaker Pro 8 file? (Choose three.)
Which three statements are true about FileMaker Pro 8 Advanced? (Choose three.)
A script containing steps that are not web compatible is triggered by a client using Instant Web Publishing. When the script reaches the first step that is not web compatible, it will _____.