FileMaker Flashcards
what is a FileMaker file?
a collection of one or more tables with field definition, layouts and scripts
what is a master table?
the table that access and displays data from another table.
what is a related table?
a table that contains related data you want to access in the master table.
what are match/link fields?
a field in the master table and a field in the related table that you can use to find matching records.
what is a master record?
a record in the master table for which you want to find matching records in a related table.
what is a related record?
a record in the related file whose link field contains a value equal to that of the link field in the master record.
what is a portal?
a layout object in the master file that can be used to show related fields.
what kind of relationship does a portal display?
a one-to-many relationship.
what is a serial number?
an auto-entered value.
what are the 4 FileMaker modes?
- browse
- find
- layout
- preview
what is each mode used for?
browse: to enter data
find: used for searches, to execute queries
layout: the backend where you can edit the file
preview: shows printer view.
how do you perform a query in SQL?
type the query and perform the find
how do you perform a query in FileMaker
- make a new layout
- choose, position, label and format the fields
- enter find mode and type the query
- perform the find
what are the 7 components of a report and how many times is each section printed?
- header: only once at the top of the page
- leading grand summary: only once preceding the first leading sub summary
- leading sub summary: once at the top of each sorted group
- body: once for each record
- trailing sub summary: once for each sorted group
- trailing grand summary: only once after the last trailing sub summary
- footer: only once at the bottom of the page.
how do you perform an AND in FileMaker?
perform a normal find but fill in more than one field
how do you perform an OR in FileMaker?
- enter find more
- type the first query
- select new request
- type the second query
- perform find
how can you do a query with both OR and AND?
by rejigging the query to only include ors
what is a report?
a list of records and possibly linked records from linked tables.
what is a group?
a set of records based on a sort on some field value.
what are 5 benefits/features of scripting?
- automate a lengthy manual procedure
- automate an error prone manual procedure
- customize/entend an application
- create a different interface
- hide backend details from the application user.
what is a local variable and when is its value erased?
a variable that is useable only in the same script and it’s value is erased when the script ends.
how do you define a local variable?
$name
what is a global variable and when is its value erased?
a variable that is usable in a calculation or script anywhere in the file and it’s value is not erased until the file is closed.
how do you define a global variable?
$$name
