Subtitles of the Movie

So, really you have a fully functional solution here that we're really going to create this whole thing. In fact we're even going to go so far as to create all the reports. Reports by Progs, report by invoice; here's a letter section, all this stuff is going to be done and you'll know how to do this if you go through all three tutorials. And we also want to show you another product that we'll be using throughout, so let's move on. The second demonstration shows you the FileMaker reference. Now I'll be using this throughout the creation of this database. This solution is also not unlocked. What we'll be doing is grabbing scripts, calculations, and graphics from this FileMaker reference. Why is it not unlocked? Well, I'm going to give you whatever we grab out of it, okay. It's going to be in there. I'm just not going to give you the whole solution, but it's an easy way to show you how to grab it quickly out of a database; I can throw all my graphics in there and just simply drag them in there. But I will give you all those graphics, all those calculations. Nothing will be kept from you. You just don't get the whole entire reference. So, let's take a look at it real quickly. You'll see on the homepage for the FileMaker Reference you have all these sections: Calculations, scripts, short cuts, graphics is down here, new features. There're all kinds of areas. We're going to be mostly in the calculations area, scripts area, and really, probably 90 percent of the time just getting graphics. So let's go ahead and look at the graphics here, and you can see what I have is a whole bunch of graphic container fields and I have these pieces stored in here, and you can see that they correspond to what you see up here, and if you walk through it you'll see that all these pieces are here. There's even a 3D look that goes around the side. All these are built like Legos, and so I'll be dragging this out of the FileMaker reference and into the invoice solution that we'll be working on. And to get back to the Homepage just simply click this and you go into the calculations section where we'll most likely be going here as in an example section, and we'll be searching for different examples because that way, instead of me simply typing out the whole formula, I can grab it, copy it and paste it, and it can save us some time because you can always pause the tutorial and look at the formula and copy it down. There's no reason why I have to spend so much time typing it out, and that way we can actually go over more material that way. So hopefully this will help you out, ah, in understanding that these two different solutions are not included inside the tutorial. They are there, but they're not unlocked. Now, let's talk about the work files. Each chapter has work files. For instance, the slides we're working on right now, looking through in Chapter 1 here, they're all included in the work files so you can look at them yourself. They're all FileMaker files so they're easy to open up. But there are also other kinds of work files like I might provide some graphics in a jpg file. I might have a table that you might want to import. Or, I might actually have a solution that's being created in there, so, in fact, every single Chapter will have the solution that we're creating. There will be a Start folder, and an End folder in each chapter, well, except for the first one in the beginner, there won't be a Start because we're starting from scratch, but every one after that will have a start and an end, and so, the start will contain the actual invoice solution which will start out as a contact manager in the beginner, that will be stored in the Start, so you have the actual file. If you, let's say, want to start on Chapter 5, we have the file that's been built up through Chapters 1 through 4, and so you have the beginning of Chapter 5, so if you just want to review,,, Chapter 5 you have that file there. And, in fact, you'll also have the end. If you want to review your work, or something like that, you will have a folder in each chapter called "end," which will have the same invoicing solution in it that's built up through that chapter. So you really have both ends: the beginning and ending of that chapter, that file. So you can start anywhere in the tutorial you want. Again, I recommend you go from beginning to end, but it's very easy for me to provide this and could be useful for you if you want to go back and review what you've done.