Exporting "Repeating Fields"

[MarkRB]

Hello All,

I have recently been trying to import a DBF File exported from FM Pro5 into MS Word for a Mail Merge, but have been running into problems where a Filemaker Record has multiple entries in specific fields. All applications I try and import this into create a new record for each entry.

The database is of a tape library so each record has a "Songs" field, some records have one entry while others have 20+.

I have got close with Mail merge but No Cigar, so have had to rethink my approach as FM seems more suited to this kind of problem.

What I would like to do is; as I export the records to a DBF file, FM looks at the songs entries and if there are more than one entries it will export each subsequent song under a new field, ie. Song2 Song3 etc..

Now, all this kind of thing is way out of my job description so what I have suggested may well be impossible or even ridiculous, So im turning to you guys.

If you have any advice or alternative suggestions they would be gratefully recieved.

Thanks 4 reading,

MarkRB