Subtitles of the Movie

Now that we've written a script that stores all of our serial numbers inside this global field in a return separated list we can use this in a relationship and this will be seen as a multi-key. In other words this return between each one of these values identifies this as an individual value in the relationship. So what we're going to do is create a relationship from X serial to the actual serial number field which is the primary key field. So we'll go into define or manage database, go to the relationship section, let's get rid of this. We'll put in a new table occurrence called invoices_save. And so it's very important when you set this up that the layout where you're going to be running the script from to retrieve be using the global field at its point. It's starting point in other words. So we want to go down and find X serial and then here we want KP invoices id. Because if you remember this is a one way relationship from here to here. We're going to start here and go this way, if we start here on a layout from there, which we don't have one based on this it's not really going to do what want anyhow because it's a dead end here. You can only go this direction. So, put that like that, click OK and so now how do we create a found set of record? Well the way to do that is with go to related record, if we run a go to related record across that relationship it will perform the find for us. So let's switch back to invoices form, let's show all of our records before we forget to do that. We have all records showing, go into Script Maker, we'll make a new script called retrieve found set and all you need is go to related record. The starting point again is invoices, so the ending point is invoices save, remember that the global X serial field is the same on every record so it doesn't matter what record you start from, it's the same on every record so it's the same go to related record no matter where you start from on invoices. It'll go to invoices save where the serial number is and find all the corresponding ones. We'll say use a current layout and then we'll say show only related records, match current record only. That's it, that's all we have to do. So let's prove it by running the script and indeed we have 7 records found. Now this is a very basic script, there's some limitations to it, it only stores one set because if you run it again it replaces the value in the global, it also uses copy all records which destroys the contents of the clipboard which is never good because the user may have something in there. In addition it does use a global and so as soon as you close the file on a multi user scenario now those values are gone. So in the advanced tutorial we are going to cover more advanced implementations of this technique and other completely different techniques that accomplish the same goal.