Combining Two Names from Different Fields on Address Labels
I'm trying to generate address labels from an Excel spreadsheet. The labels are for parents of students. In the original Excel database, each student has two rows (one per parent name). In my labels, I'd like to have the label say "Jane & John Doe" or "Mary Smith and John Doe." The students are identified by a unique ID number, so there is a connection between the student and parent names. Right now, each student has two records (one record per parent), and that results in two address labels per student. Any help is appreciated. I'm using FM 10 Advanced for Mac.
Thanks in advance