Hi I am filemaker pro advanced 14 user on Mac.
I have created a table with Customers (customers have primary key and one and the same _kf_DosierNumber to link them to Dosier and
Dosier, (_kp_DosierNumber ) One Dosier can have multiple customer (linked via keys)
and a table with a travel itinerary. One travel itinerary can have more than one customer and are linked via _kf_foreignkeys. Using DosierNumber
All that works fine. i can select the Dosier number with many clients in my itinerary and bring it in a portal.
I have an email that prepares all details to a hotel. what i am looking for is how do i link two or more customer names to an email via a calculation. it is currently only picking up the first name.
Extract of send email options via outlook using calculations:
Clients::Title &" "& Clients::Customer first name &" "& Clients::Customer last name &"¶¶"&
The client dosier does pick up the number, but the last sentence only picks up the first name of the dossier. i probably need a bit of coding here using a loop?
Your help is appreciated.
Sorted, this was a lot easier if you know your way around. i am using the set field and list function. works a treat. cheers