FileMaker
FM0-307 · Question #18
Given two tables, Customer and Invoice, related such that customer:: CustomerID = Invoice:: CustomeriD, and a summary field in Invoice, InvoiceCount, defined to count the InvoicelD field. Which two…
The correct answer is A. Count (Invoice::CustomerID) E. ExecuteSQL ("Select Count (CustomeriD) from Invoice where CustomeriD = ?" ; "". See the full explanation below for the reasoning.
Question
Given two tables, Customer and Invoice, related such that customer:: CustomerID = Invoice:: CustomeriD, and a summary field in Invoice, InvoiceCount, defined to count the InvoicelD field. Which two functions could be used as a field definition in the Customer table to count the number of related invoices? (Choose two.)
Options
- ACount (Invoice::CustomerID)
- BValueCount (List (CustomerID))
- CGetSummary (Invoice::InvoiceCount)
- DExecuteSQL ("Select Count (Invoice::CustomerID) from Invoice"; " " ; " ")
- EExecuteSQL ("Select Count (CustomeriD) from Invoice where CustomeriD = ?" ; "" ;
How the community answered
(23 responses)- A83% (19)
- B4% (1)
- C4% (1)
- D9% (2)
Community Discussion
No community discussion yet for this question.