Click the Exhibit button.
You have a FileMaker Pro 8 layout based on the table occurrence Teachers. You have a portal showing records from the table occurrence Students.
What happens if you place the field Classes::Class Name into the portal?
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 )?
Click the Exhibit button.
Your database has four tables: Customer, Invoice, Line Item, and Product. The relationships are displayed in the Relationships Graph exhibit.
Your users want to select a group of customers and then view all unique products purchased by those customers.
Which two techniques successfully accomplish this without changing the Relationships Graph? (Choose two.)
A layout contains a portal that allows creation of related records. What are two techniques that can be used to navigate to the empty row at the bottom of the portal? (Choose two.)
The return delimited data in the Contact field of a FileMaker Pro 8 database are:
John Smith
Mary Jones
Julie Hyde
Which three formulas can be used to extract the string "Mary Jones" (without quotes) from Contact? (Choose three.)
Click the Exhibit button.
You want to build a FileMaker Pro 8 database that models a business organizational chart. One person may manage zero or more people. One person may be managed by at most one other person.
You want to build the system in such a way that a single layout showing information about a person can display both the name of the current person's manager (if any) and the names of all people managed by the current person.
What is the minimum number of tables you must define in the Tables tab of the Define Database dialog to construct the layout?
