June 24, 200520 yr Newbies 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
Create an account or sign in to comment