Subtitles of the Movie

Let's go quickly back to our Customers and take a look at something we did to our Invoices tab. Before it was based on a different table occurrence than these ones. And that caused a little bit of a trouble because if we did a Find on one of these, then it wouldn't be the same find as was on this one, but now they're the same. They contain the same found set and that's because they're based on the same table occurrence now. So, we did this because, first of all, it was causing trouble with that Save and Restore TO scripts we wrote, and in addition it just didn't make sense. If you wanted to do a Find and end up on Customers and go, Oh, let's go look at invoices, it would be a different found set and it was just confusing. So what we had to do, well, we went into Manage database and what we used to have was another table occurrence of Customers going to Invoices. Now what we have is Customers going to a table occurrence for Invoices. It's exactly the same relationship; no difference. Same four fields, exactly the same, but what we've changed is the starting point. The starting point is now Customers and the ending point is now Invoices. What we had was another table occurrence as a starting point and the ending point this Invoices. It makes exactly the same result, just helps us out better in this situation. So what we had to do was go into Layout mode and we went into Layout setup and we changed this from Show records from the old Customers and now choose the Customers which is the same as all these other layouts that we see up there. And then we, of course, had to go through and change a lot of things. We had to change this right here, this merge field was Table unknown, because I eventually deleted that table occurrence. We had to come in here and change all these global fields. Didn't have to but it just makes it look nice; otherwise we'd have had colon colon, but since they're globals it didn't really matter. And we had to come in and change this portal right here, and then each of the fields in there, so now we have Invoices by Customer and in here we had to change it to Invoices by Customer, as well as we had to come down here and change this; these had a problem, we had to just come in here, take one letter out, put it back in and that fixed it because when you change it those merge fields, for some reason, can't catch up with the Change to Layout setup that we did in here and you have to just make it think about it again by changing, modifying it slightly. And that's about all we did. We didn't come in here and change this, but we could. If we did, it's really going to be into our globals. We don't really need to do it here, that's why we didn't do it here. But we could do it on this one because now it's, well, it's the same thing here. Looks like we didn't change on either of these ones because they're both pointing toward our globals. So, that's going to be a related field no matter what. So. But everywhere else we had to change it and so what you want to do is go through and make these modifications to your Invoices layout. It's going to work much better than the setup we had before and hopefully what this has done is taught you a little bit about how table occurrences work and about how starting and end points can really make a big difference.