Subtitles of the Movie

Here's one of my favorite features, this color wheel. We can colorize any number of table occurrences any way we want. You might decide, well, I want to go ahead and color all of the customer table occurrences one color. You could go through and shift click that or you could click one and say select related tables one way, which is kind of a neat feature; I'll take a tangent here and show you. All the tables that are related one hop away get selected. Sometimes you usually see it with invoices here. But see that this is one away, this is one away, this is one away and so on. In fact, lines is probably even easier, but see, only these two. But I like to use this one. Select tables with the same source table. Here's all my customers. I can now change them to the same color. Now I can easily recognize which ones are customer tables and then you can go through and do the same for each one of these. Go through here, make this one blue, make this one, uh, purple and let's just leave this in gray since it's italicized, which means it's not a local table. That might be a good way to identify that. You could also colorize them by base tables. Make all your base tables or, they're not really base tables, but you're structural relationships all one color so you can easily see it real quickly. There's all kinds of things you can do. Experiment with it and see how it works for you. You know, of course, there's the arrow tool. That's what the default is. Here's your text tool. If you draw a little text tool here, it brings up a sticky note and you can type in information about relationships here. And you can change all kinds of settings here. I'll just leave it at the default. And you can move this around, toggle it if you want, resize it if you want. If you get right on there you can resize it. All kinds of things you can do here. And then we have our pluses and our minuses. So let's click on the minus here, come over here and see that we can reduce this. We can go as far down as we want. In fact, we can turn on our page breaks here so we can see what's going to print. Ok? So obviously this is going to print not on one page unless we change the print setup and then it'll be landscape and it'll probably fit. It's a great little feature and then we can come over here and turn that off and we can get back to a regular size by using the plus size if you want, or we can hit this button or we can go ahead and type in 100 percent. We could do 100 percent and get back to that if we wanted to. It's up to you. Each one of these features will help. And now there's one thing that there's really no feature for here and that is what I like to call grouping of your table occurrences. There's an infinite number, it seems like, of techniques for this but I'm going to show you the basic idea behind this and what we're going to do is add some table occurrences here; one for invoices and then one for customers. And we'll move these down here and we're not going to attach these in any way to the rest of the relationship graph. We can simply make a relationship here as long as your layout is based on one of these and our related fields is based on another, they don't have to be connected to everything else. Now, of course, if we want to have some other information like, maybe lines connect to this as well, then we're going to have to add another table occurrence and they actually may be the same as one of the table occurrences that we already have up here. So the advantage is you can make it easier to read your relationship graph. Imagine having 10 or 20 tables and all the table occurrences to go along with it and they're all connected. It's this big, hairy mess and then imagine kind of dividing them out by feature or, or set of layouts or whatever or functionality and making groups of table occurrences. Well, you get a benefit of having a much simplified section over here you can go to, but the disadvantage is you end up recreating some of the relationships you might have in other sections. So this is just really an introduction. You might want to think about this. It's more of a, you know, a high-end developer's technique to, to separate these. As you're starting right now, you're really not going to need this because we have a simple graph here. It will never get too complicated. But I have designed some where I have, oh, gosh, dozens of table occurrence graphs. So we're going to get rid of this; just giving you an idea. Nothing really more than a theoretical technique here at this point. So we'll remove those and that's about it for you. Fiddle around with this relationship graph and see what you can do with it, organize it the way you want, play around with it and fiddling around with things is really a great way to learn.