FileMaker Workshop

Created Feb. 7, 2024 by Thomas McClain


Application


Client

An application that makes "requests" of a system (Takes)

Server

An application that handles "requests" of a system (Gives)

Database Terms


Concepts

Manage Database

  • Value - data
  • Fields - "container" for data (see Data Section).  
  • Rows - tuple - holds multiple fields
  • Tables - holds multiple rows
  • Database - holds multiple tables
  • Relationships - entity relationship diagram (ERD), build connections to "join" data.
  • Keys - relationships have a primary_key and foreign_key

Views

  • Form - "Google Form"
  • List - "Rolodex"
  • Table - "Spreadsheet"
  • Preview

Modes

  • Browse
  • Find

Data

Data can have a type of:  

  • Text
  • Number
  • Date
  • Time
  • TimeStamp
  • Container
  • Calculation
  • Summary
Return to top