Subtitles of the Movie

So let's demonstrate how this works and let's create a new record. Now we could go up to the Records Menu but if you design your solution well you won't have a Records Menu. You'll use Custom Menus to design this for your specific solution. You should really have something specific to that solution because there's way too many choices underneath here. People are not going to use all these choices, they're not going to use Show Minute Only and, and Modify Last Time. Maybe they will maybe they won't but if you don't need it in your solution don't provide it. Therefore, use Custom Menus or use buttons and if you use a button you can put a name on that button. If you use Custom Menus, you can put in whatever you want there, not New Record. So make your solution, it's your job as a Developer to make the solution easy use for users. In fact my goal is that they won't have to do anything, it'll just make sense when they get into it. So we're going to create a New Invoice here. And you'll see the first field in the tab order is the one to select the Customer. So we'll choose Apple Computer, it fills it in; these are all related fields here. OK, come down here we're going to choose some products that they want to purchase. So we'll choose a dragon fly lamp, maybe they want 2 of those and we'll come down and choose another product, maybe the one, a flower lamp, maybe they just want 1 of those. So you filled out an invoice, you have the ability to Print it, Delete it, Duplicate it. We'll get into those during this tutorial but let's also go look at some of the navigation areas. You can walk through the records if you want. We've Scripted this, notice that the status area is not showing. A good solution should re-create the status area because that's using up a lot of space that you can use for other things in this limited screen real estate area. You can go to List View and you'll see all of these invoices, here's the one we just created. If we click on this button, it takes us to the Invoices View so you can see the entire invoice. We can hit Find, come in here and Search for anything we want. Choose Build, hit Continue and it finds all the billed invoices. So you can see that this is a very powerful solution that makes it every easy for people to use if you design it right. In fact you'll notice that we can also switch over to another section, we can go to Customers. Now you could do this with Custom Menus as well. I show this technique for people who don't have Custom Menus but it really, when you see us work with this we'll actually put a menu up here that allows you to do the navigation through that rather than clicking once in here and then clicking the button. But once you get going you can flop between customers and invoices very well. So in the Beginner tutorial we're going to start creating this and then eventually we're going to get to invoices and create all this. Now there's a lot I haven't shown you but hopefully this gives you an idea where we're going with this solution. So let's go back to our slides here and let's demonstrate another solution. There's a 2nd solution called the FileMaker Reference. This solution is also not unlocked. This is a commercial solution I sell but I'll be grabbing things out of it. Anything I grab out of the FileMaker Reference I'll give to you in the Work Files. That doesn't mean I'm going to give you the whole FileMaker Reference but I do it to make things work faster, to quickly get a graphic, get a calculation, get a script, things like that. So, but anytime again I do that I'll go ahead and provide that calculation or that graphic to you. So I want to give you a short little description of how this works. So we'll show Window and there's FileMaker Reference and since we're going to be spending most our time in the Graphics area, I'm going to there first. And as you can see, there are container fields here. That's one record, here's another record, all these graphics go together and they correspond if you look down at the red correspond to this. There's one piece, the outside, there's another piece right there then there's the middle piece. We'll get into more on how this works but all the graphics are in here and you can drag them from this FileMaker File into your FileMaker File and we'll be doing that quite a bit. And we can go back to the main area. We can go into Calculations and you'll see that we have tons of definitions here but also we can go into the Examples and grab different formulas and I'll be doing that. I'll be searching in here, finding a formula, grabbing it, pasting it into my solution so that's the idea behind the FileMaker Reference. We'll give you everything that we copy out of here in the work file section so don't forget about that. Here we go, and let's talk about the work files, we've mentioned them but let's get more details. Each chapter has work files. Work files could be supplementary files like Graphics, Tables, you know Tables you might import into our solution and, and in fact in every single work file for each chapter there will be actual solutions that you will be creating. We'll have the beginning and the end. So in other words when we start the chapter we'll have the state of the file at that point and when we end the chapter we'll have the state of the file at that point. So this will help as far as reviewing things. You can go back and review a chapter without going through the whole thing because you'll have the beginning of that chapter. You can grab that file and follow along with it. So don't forget, look inside the Start Folder and you will find that you will see that there is a Start .fp7 file. And so look for that file and you will be able to start off on any chapter you want, review it, do whatever you want and a lot of people miss this Work Files area. Don't miss it, find it right away because you're going to really need to use it, it's going to be really helpful for when you're going through these tutorials.