Start learning with our library of video tutorials taught by experts. Get started
Viewers: in countries Watching now:
In FileMaker Pro 11 Essential Training, Cris Ippolite demonstrates the principal features and functions of this popular database software, including creating tables and relationships, managing fields and records, and working with layouts. The course shows FileMaker developers how to find, sort, and share data as well as how to create reports, calculations, and scripts. It also covers brand new features in FileMaker Pro 11 such as the Inspector tool, charting, and portal filtering. Exercise files accompany the course.
In the previous movie, we determined that we needed a Customer table and an Invoice table and a Product table in order to be able to create our new FileMaker database. In this movie, we're going to talk about how to physically add those tables to your database. Adding a table is going to be the very first step in creating a FileMaker Pro database, so this is really going to be the first step in us creating the database that we're going to be using for the rest of the title. Creating a FileMaker database from scratch will always start in one location, and that is under the File menu, where you'll see File > New Database.
When you choose New Database, you'll be asked what you want to name the file and where you want to name it. You'll see that all FileMaker databases end with .fp7. That's a file format suffix for FileMaker Pro, and in this case, we'll just call it Untitled, and we're going to choose to save it to our Desktop. Once we've made those decisions, we can hit Save. And now you'll notice that its created a FileMaker Pro file for us, and its taken us to the Quick Table View layout that we discussed in previous movies. So you'll see here, we've got a layout already created for us, and if we go back under the File menu and choose Manage and Database, you'll see that we've got three tabs.
We're going to focus on the tab for Tables. And here you'll see that it has already created one table for us. And what you'll notice here is that it has taken the name of the file, so whatever name that you choose when you're naming the file becomes the name of your first table. Traditionally, the name of your file won't necessarily be the name of any of the tables inside of it, but FileMaker Pro takes that name because it does have to name your title something. So really the first thing that you're going to want to do is change the default table to a name that represents one of the tables that you want to define in your file.
So let's pick Customers. And you'll see what we do is we just type the word "Customers" in the table name, and while we have the table chosen, we're going to hit the Change button, which is now going to change the table from Untitled to Customers. So now we've got one of our three tables already defined inside of our database. And if we want to create a new one from scratch, we just simply type into the field. In this case, we want to add our second table, which is Invoice. But this time we're going to hit the Create button, so that it simply creates the table for us, as we see in the Table list above.
For the third table, we're actually going to bring in a table that exists in another database we've been working on. So let's say in this case that we had a Products table that was in FileMaker, but we wanted to integrate it into our new invoicing solution database, so instead of creating the new table from scratch, we're going to import one into the system. So first we'll hit OK. Then we go File > Import and choose the File option. Now, our Source database has several different tables in it.
We're going to choose the one that's called Products. You can see all of the different product fields here, and we're going to choose the New Table option, which of course is going to create a new table and define all these fields for us. So simply hit Import, and now we see we've got records and fields chosen, but most importantly, when we go back into Manage and Database and look under the Fields list, now we have all three tables that we've determined in the previous movie were required for our database. You see all three of those tables now defined within our new FileMaker Pro database.
And here I just wanted to demonstrate that we've got some information about our tables. We've got Customer, the name, and then some details on how many fields and records. We don't have any fields defined in these first two, but we'll see that by importing in a table from another source, we're able to bring in, not only the fields, but also records from that other source. Once we've created the tables, we can then move on to create the fields, but also when we have multiple tables, we can evaluate what types of relationships they might have between them. So now that we've got our database created, or the shell of the database created, we can start adding things like relationships and the different things that we'll cover in the upcoming movies.
Find answers to the most frequently asked questions about FileMaker Pro 11 Essential Training.
Here are the FAQs that matched your search "":
Sorry, there are no matches for your search ""—to search again, type in another word or phrase and click search.
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.