Which two statements about relationships are true in FileMaker Pro 9? (Choose two.) A. The > operator only works using numeric match fields. B. It is possible to create a valid relationship where one match field isunindexed. C. The relationship operator % (contains) allows the relationship definition to include Allow creation of records in this table via this relationship. D. The relationship operator X (cross product), allows the relationship definition to include Allow creation of records in this table via this relationship. E. The relationship operator <= (less than or equal) allows the relationship definition to include Allow creation of records in this table via this relationship. Answer: B,E QUESTION NO: 72 A FileMaker Pro 9 database contains two tables: Customers: customer_id, first_name, last_name Invoices: invoice_ID, customer_ID and invoice_date When looking at an invoice, a user also wants to view all other invoices for the same customer. To create a portal that shows all invoices from the same customer as the current invoice, excluding the current invoice, the user needs to create a relationship between which of the following? A. Two occurrences of the Invoices table where B. Two occurrences of the Invoices table where invoice_id = invoice_id C. Two occurrences of the Invoices table where invoice_id ? invoice_id D. Invoices and Customers where Invoices::customer_id ? Customers::customer_id Answer: C 26
QUESTION NO: 73 Exhibit: *missing* FileMaker FM0-303 Exam A user wants to build a FileMaker Pro 9 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.). The user wants 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 that must be defined in the Tables tab of the Manage Database dialog to construct the layout? A. 1 B. 2 C. 3 D. 5 Answer: B QUESTION NO: 74 Exhibit: *Missing* Consider a FileMaker Pro 9 database with two tables called Salesperson and Order, and a relationship between the two tables based on a Salesperson ID field. The relationship is configured as shown in the Exhibit. There is a layout called Salesperson Detail, based on the Salesperson table occurrence, with a portal showing Order records via the above relationship. Which three statements are true? (Choose three.) A. Deleting a Salesperson record also deletes all related Order records. B. It is possible to create new Salesperson records by importing data into the Order table. C. Users may create new Order records by entering data into the portal on the Salesperson Detail layout.
You've reached the end of your free preview.
Want to read all 34 pages?
- Winter '20
- Computer file, FileMaker