Show all days worked on flyer
My contacts work in booths on friday, saturday, or sunday or any combination of thes days. In my yearly flyer I need to show the booth and the day or days they worked in that booth.
How do I show multiple days on the flyer?
Do I use a relationship between booths and contacts or a looping script to build a field that collects the days worked?
Typical fields are: FN, LN, Booth, Booth Day Name. Tables are: Booth and Contacts related by Booth ID.
Thanks for assistance,