Username:
Password:
FileMaker Pro 10: Beginner Tutorials

Introduction / Why an Invoicing Solution? pt. 1

Subtitles of the Movie

All 3 tutorials will use the same Solution and Invoice in Solution. And you may be asking me why did you choose an Invoice in Solution. Well first of all it's a familiar solution to almost everyone. Everybody buys and sells products. You go to a store, you go on the Internet, you may even have your own business where you need an Invoice in Solution, everybody's familiar with it. Now I could have chosen something like solution based on schools attracts students and teachers and classes and things like that. And most people would have been familiar with that but I don't think quite as familiar as with an Invoice in Solution. So everybody's familiar with this, right away you understand what we're covering, what we're trying to do. So I want that buy in, that understanding right when we start using it. It also allows me because I'm using a solution, one solution throughout the whole series, allows me to show the techniques in context. So, any solution would have done alright but I just think an Invoice in Solution is better and specifically a solution is good because rather than showing random techniques, showing the how to do this technique in this file and then using another file, I put it all in context so you can really understand what's going on and understand the development process. So an Invoice in Solution is simple enough to create a complete solution in the time we have yet complicated enough to show advanced techniques. It's really, hopefully you understand that. We have enough time to complete the whole Invoice in Solution but we'll also have a level of complexity within an Invoice in Solution, we could just use some great techniques. In fact, all of the techniques that you'll find inside of an Invoice in Solution, I would say 90 of them, will be applicable in one way or another to any solution you might be developing. For instance, you need to learn how to create a Menu-to-Menu relationship. So many people don't know how to create Menu to Menus and they're crucial for almost every solution that's more than a couple of tables. Need to know how to join 2 Tables together with a Join Table, that's a menu to menu. And so many people don't know how to do it and they just skip it and they can't really get accomplished what they want to get done. And an Invoice in Solution will show you how to do it and you can take what you learn from an Invoice in Solution and directly apply it to any Menu-to-Menu relationship. Now any solution that has more than one Table will have a one to Menu relationship for sure. So we will do those inside of Invoice in Solution and you can apply that to any solution you're going to do out there that has more than one Table. Of course if you have more than 1 Table, you'll probably have portals, related fields. All these relational concepts are very important to get established. And by doing it in the context of an Invoice in Solution, you'll understand how to apply to any solution you'll be creating. In addition, we'll be creating Scripts. Now they'll be specific to an Invoice in Solution and some of them will be applicable to any solution. Some of them will be very specific to an invoice solution. But think of it like lifting weights, you lift weights so you can be better at football or basketball or maybe you just want to look good in a tee-shirt, whatever it is, the same thing applies as Scripts. If you learn how to do a whole bunch of Scripts, whether they're the specific Scripts you want to do, it'll help you build up your skill set. So you can take all of those Script Steps that you learned and apply them in different ways. And the same goes for calculations', learning all the functions, doesn't require you learning a specific calculation for your solution. It requires you to understand how calculations work. And by doing any solution you'll understand that. So what we want to do next is give a demonstration of a completed Invoice in Solution. This is a commercial Invoice in Solution that I sell. It is not unlocked, you will not be able to get into it and pick it apart. The reason I have it in the work files area, wherever you're getting this from, whether it's online or on the CD. The reason I have it on there is to give you a goal, to show you where you're going. I don't want to just start creating the solution and you have no idea where we're going. I want you to see the ultimate goal. And if you follow along all 3 parts of this tutorial series, then you will actually have built this entire solution I'm going to show you. So don't worry about it if you actually build, just don't watch, you build it. You actually build the solution, have it exactly the same way as you see it right now. So let's take a look at this, we're going to go Show Window, Invoice and here's Invoice in Solution. Right now we're looking at the invoicing portion where you're going to spend most of your time cause you're going to be creating invoices as people come into your store. There's a section for Customers, there's a section for Products and there's also a section for Details, like the carrier and the tracking number and terms and all that kind of good stuff, tax and shipping.

Tutorial Information

Course: FileMaker Pro 10: Beginner
Author: John Mark Osborne
SKU: 33925
ISBN: 1-935320-18-1
Release Date: 2009-01-05
Duration: 15 hrs / 172 lessons
Work Files: Yes
Captions: Available on CD and Online University
Compatibility: Vista/XP/2000, OS X, Linux
QuickTime 7, Flash 8

VTC Sign up & Benefits

  • Unlimited Access
  • 81,350 Video Tutorials (20,800 free)
  • Video Available as Flash or QuickTime
  • Over 782 Courses
  • $30 for One Month Access
  • Multi-User Discounts Available