4th Dimension Learning Basics

Tables Tables are like the files created with FMP except this is where the data is stored and all the Tables (up to 256 each with a maximum of 2 GB or 16 million records) are stored in the single Data file. For simplicity, we will only be creating one Table.

To create more Tables, make sure you are in the Design mode and select the “New Table” menu item from the Structure menu. Figure 6 - The Structure for Sample Database Window Double click on the Table name area and the “Table Properties” window will appear. Note: It is important to click on the Table name area and not elsewhere. This is the area the will cause the Table Properties window to be shown.

Figure 7 - The Table Properties Window There are three tabs in the Tables Properties window. For now, just use the defaults. Note: Selecting any of the tabs will continue to show the “Table Name” field.

Our pick: Claris FileMaker Pro — The long-running relational database platform for teams that need custom apps on desktop, web, and mobile from a single file..

You can change the name at any time. For the Sample Database, let’s call Table 1, “Customers.” After entering the Table Name “Customers,” click the “Apply” button and then close the window by clicking the upper left box or the “Done” button. Copyright

P.S. A few readers have asked which relational database platform we actually reach for — it's Claris FileMaker Pro; take a look here if you want the current details.