Now let’s look behind the scenes at the actual tables inside your solution.
FileMaker Pro automatically assigns table names when you convert or import a spreadsheet, using the name of the spreadsheet or workbook involved. Sometimes this works well as a table name, and sometimes it doesn't.
Let’s change the table names so they accurately convey what the tables represent.
Look at the tables in FileMaker Pro’s Manage Database... dialog box.
- Choose the File menu > Manage > Database ⇧⌘D or Ctrl-D
The Manage Database... dialog box appears.
This dialog box provides access to many important aspects of your solution. It allows you to rename tables, to create, delete, and modify fields, and to establish relationships — which is why we’re using it now.
- Select the Tables tab at the top of the window.
The Tables tab lists the tables in your solution.
These table names were assigned by the conversion process:
The first one, “Landscaping”, was created when you converted your first spreadsheet.
The second one, “_Landscaping.xlsx_ Work Orders”, was created when you imported the Work Orders worksheet.
Let’s change these table names to something more informative.
- Select the first table in the list (“Landscaping”).
- In the Table Name field, change the text from “Landscaping” to “Customers”.
- Click the Change button on the right.
The table name in the list changes from “Landscaping” to “Customers”.
Note that the screenshot above is from FileMaker Pro Advanced. In FileMaker Pro, only the Create, Change, and Delete buttons will appear.
- Select the second table in the list.
- In the Table Name field, change the text from “_Landscaping.xlsx_ Work Orders” to “Work Orders”.
- Click the Change button again.
The table name in the list changes from “_Landscaping.xlsx_ Work Orders” to “Work Orders”.
- Click the OK button in the lower right of the Manage Database… dialog box.
You are returned to the layout.