do you have one table from which you are pulling the data or two? what is your table structure for the table(s)?
if your 2nd table already has client information and the additional guest client info, then you may not have to load the same field twice in two different tables. you obviously need to load your reservation id in both the tables to associate the data in the two tables.
can you post a sample of your data here? probably easier that way than trying to troubleshoot what you may have done or could do.
A simple fix is to load the address data twice. Once into a Client table, and again into an AdditionalGuest table.
The filed names in these tables must be unique, otherwise you will get a loop in your data.
from AddressData ;
ClientID as GuestID,
Address as GuestAddress ,
City as GuestCity,
Country as GuestCountry
A more comprehensive fix would be to change your data so the ClientID and GuestID are loaded into a Reservation / link table. This links the single reservation to multiple guests, you could include another field to identify the primary contact and additional guests, this way all guests link via one address table.
Thanks, Colin! The two different tables is the obvious and easy way, for sure :-) That was the way I did it first. But then if I wanted a single email list for export, this method won't get me there. I need one for each dataset.
I love the idea of a "bridge" table (I have built those before in other views but didn't think of it here...) I will give that a try.