Hello!

I have a file with three tables:

First Names | Middle Initials | Last Names

I am trying to output every combination of one field from each table. Specifically, formatted like so:

<record>

<first>John</first>

<middle>A.</middle>

<last>Doe</last>

</record>

I believe this should be done using the null relationship (X) between each table. Then, using a script that loops through each record set and inserts the result into a global field in the first table. I've also thought about using counters and a layout with two portals to do the looping. I can successfully loop throught the first names and could setup a script for each name then eliminate duplicates, but I'd rather learn the right way to do it.

Does anyone have nested loop scripting experience they can share with me?

Here's how I loop through the first names:

My script is bloated with the unnecessary "go to related records" because I figured they would be necessary once I figured out how to loop through the other related records, btw.

<added>and my actual script didn't use "select contents" on every insert... lol</added>