hi. i'm using FM for the first time on my mac. i'm a musician trying to create a database of local schools so i can do a personalized mailout.

i want to choose whether the script is sent either to the head teacher or the music co-ordinator (and occasionally letters to both).

can i have the two contacts in one school file, and then select which one i want to use for the mailout by editing the layout? or do i have to create a separate related file for additional contacts?

i have read the manual, but being a musician, it's little technical. many thanks!

Edited October 17, 200718 yr by Guest

All you need to do is a Find for the type of contact you want.

As far as structure, it's best to use the person as your entity (one person is one record). Keep related school info in a separate table.