Wow! Each table occurrence maintains its own found set. I would never have run into that useful tidbit of information on my own. Thanks for the link!
Great, thanks for the link! I'll have to play around with this and see if my amateur self can get it to work.
OK, so I'm having some trouble with this.
If I'm understanding correctly, first I copy the table that I'm using, then I create a new table based off of that, which includes copies of all the fields from the original table. Since I have an existing database I don't need to create the initial table and layout for that table since I already have them, correct? Then I'm suppose to create a new layout and set the "Show records from:" in the Layout Setup to the new table? When the author of that article says "Create a second table occurrence based on the same table and call it DATA_FOUNDSET and add a layout based on this table occurrence," I assume he's talking about this?
Then in the Go To Related Record script step it says to set the first drop down menu item to the original table occurence. Then it says to select the layout to show the records as the layout for the new table occurence, but since that layout is set to show records from the new table and not the original, it isn't given as an option for the layout you can choose here, there are only layouts displayed here from the original table.
What is it that I'm not understanding correctly or doing wrong?
> If I'm understanding correctly, first I copy the table that I'm using, then I create a new table based off of that, which includes copies of all the fields from the original table.
No you don't create a new table but a new table occurrence. This means adding a new box into the relationship graph. The two table occurrences are based on the same table.
Thank you! That did the trick. Forgive the amateur/novice! Works perfectly now.