All three tutorials: the beginner, intermediate and advanced will use a single solution throughout. And the solution I've chosen in an invoicing solution. And you should be asking yourself why? Well there's a very good reason why. I've been doing FileMaker training for about 17 years now and I found out that having a single solution throughout the entire tutorial helps you to really grasp onto the techniques. If you just see one technique here and one there, well it doesn't really help you as much as seeing it in the context of a solution. So what I want to do is pick a solution that was familiar to everybody. Everybody knows about invoices and contacts and products and selling those products and printing them. And so you can instantly grab onto what I'm trying to talk about here. The concepts will be easy to understand if I chose something like let's say a school solution where we had students and teachers. All that might be pretty familiar to most people but I think the buying and selling of products is really the best solution out there for everybody to understand. And what you want to imagine here in this situation is this is an invoice that really is geared towards a business where you buy and sell multiple things almost like a storefront. I actually use an invoicing solution in my business where I sell products and services, and so this is how this is designed to work, this invoicing solution. Now there are many kinds of invoicing solutions but I wanted to take the most simple, the easiest to understand approach to an invoicing solution because that will help us get into all the different techniques we want and cover things that everybody wants to know. And so the invoicing solution is simple enough to create a complete solution yet complicated enough to show advanced techniques so that's really my point here is that you can do anything you want in and invoicing solution. It has so many aspects to it. So it's really quite well suited for this. And the great thing is that anything you cover in an invoicing solution really applies to any other solution you might make. For instance, just about every solution that's at least a couple of table will have a many to many relationship and a one to many relationship. They'll have portals. They'll have related fields. They'll have scripts, calculations. We can show all these things inside of an invoicing solution and you can take it and with very few changes apply it to whatever solution you need to do. It really does work that well. Once you learn how to do a many to many relationship in an invoicing solution you can take and you will understand how to apply that to any solution with a many to many relationship. It really is that what you see in an invoicing solution can really be replicated into any solution. And once you get, once you understand it and once you've transferred the ideas from invoicing solution to your solution you'll really get that. So what we're going to do is demonstrate an invoicing solution, a solution that I sell commercially. This solution is not unlocked. Ok. It's locked. You will not be able to get into it. It is included in the work files and maybe included several times whenever I mention it but I use this solution to present a goal for the series. Where are we going? I want you to see off in the distance where you're going to get to if you go through all three tutorials. Ok. So if you follow the entire three part tutorial series you will have created the invoicing solution I'm going to show every little last bit of it. You really will. So you really don't need to have this invoice solution unlocked. You really don't need it because if you go through the whole thing and as I'm doing it your building it you'll get the exact same product. But again, we're showing it here just so you can see where we're going. So go to the Window Menu. You'll see invoice and here is one of the layouts in the invoicing solution. You can see that we have tabs. We have buttons. We have customer information for billing and shipping. We have products. You can add as many products here as you want. We have information about shipping, terms. We have our information about how much they are spending including shipping and sales tax and all that kind of stuff. It's all here in this section. And so let's start by create a new record. Now I could do it from the Records Menu because I have complete access to this file or I could use the button. And really when you lock out all these menus from the users because they really shouldn't be going up to the menu and using them if your making a solution for other people to use. They should have to know FileMaker to use your solution. You should have a button here. Make it easy for them. So we'll do that, new invoice. Automatically pops up, your list of customers. Yours will likely be longer. We'll choose FileMaker Incorporated, fills in all the information here. Then we can come down here and choose which products we want to see them; maybe a Tiffany dragonfly lamp. And maybe they want two of these. And when your done you'll see the totals show up here at the bottom. You can choose the status of it whether it's billed or paid. All that information goes in here and is stored in various tables. For instance, this information from customers and this is from products. And there's also a join table here, which you'll learn about later, which is actually storing this so there's actually a products table and a join table that joins products to invoices. But we'll get into that. That's fairly complicated stuff. Let's also look at the navigation here. We can go into list view. See all of the invoices that are in here. There happens to be six right now. And we can click on any one of them to view it. So we can go over to here. This one happens to be for FileMaker also. We can go through and walk through these records, these invoice records and see all of them. There's one for Apple computer. I can also do a find if I want. I can find all the people that have been billed. Hit Continue and it shows me just five. Only one of them is paid right now. Go back here and we can still see those five. You can see this feedback right here. We can walk through them again. So you notice that what we're building in here is all the functionality so people don't have to go up to the View Menu and choose Find Mode. Now you need to know how to do this but once you learn how to do this you can make buttons and interface that do all this stuff so people don't have to know everything about what to do. They don't have to know that you can't search really inside of a global field because they could get into that one in Find Mode. You would simply set up the script in Find Mode. You'll also see there's special filter portals here where I can say only show me certain values between certain dates or only show me the paid ones or only the billed ones. So you can see how this filter's this portal and gives you ad hoc reporting. We can even go over the customer section. You can see all the customers' area here. If I want to find all the companies who are starting with A, I can just hit this button. And you can see now it changes to one of one. And there's Apple computer. I can go into Find Mode here as well. There's a filter here as well, all that kind of stuff. I can even pop this up and choose products. I can go right over to the products section and you have all the information about the products here.