wimverbe

I am sort of stuck. I created a contacts database, with lots of functionality, search scripts, automatic mailmerge etc. then they asked to adapt it "a bit"... each record (company name) has 1 up to 4 contact persons, each with their own set of fields. the question is to be able to print labels and letters to 1 or more contact persons from the same company. e.g. company A has contact persons a1 and a2 company B has contact person b1 company C has contact persons c1, c2 and c3 I have markers next to each name, to define if they should receive mail or not. Now I want to mailmerge to persons a2, b1, c1 and c3, so I need following labels: company A attn. a2 company B attn. b1 company C attn. c1 company C attn. c3 I tried to do it within a single database, but couldn't figure it out, especially with the labels. I found it impossible to print more than 1 label from 1 record. then someone in the Scriptmaker forum suggested I make a relational database, the second one having one record per contact person, and printing from there. technically, it does not seem so difficult, but conceptually it drives me nuts: what should be the match field? (2 companies can have the same name) when creating a new record, how will the new 1-4 records be created in the related file? how do I transfer all the existing fields with contact names etc. to separate records? when scripting the print command, (which is done from the master file), how do I make it continue running in the related file? these are all questions I could not find an answer for in the manual, and I did not find an example file that did exactly what I need. thanks, Wim

Sharka and Jason, thanks again for the input, I'll go for the splitting up after all. it's just that I thought the label thing would be a minor addition to my program, I was only told there would be more contacts per record after I defined my time estimation for this programming, so time is up and I was hoping for a quick solution. tnx, love this board... wim

Sharka, thanks for your input, but I still can

I need to make a script which prints labels from a contact database, but the problem is some records have 2 or more contact persons per company, and a label with each of the persons has to be printed. Is there an easy way to do this? tnx, wim