I am currently trying to import a selection of records from Filemaker 5 pro into MS Word2000 via a DBF file export.
My Problem is this; The data is a list of tapes with fields like artist, title, format etc but when it comes to the songs, if a tape has more than one song then Word sees the following songs as new records as each song has the same header.
As each record that is just a song has a blank artist field I have been trying to use a Field Code but am having a nightmare getting the syntax correct.
What I am aiming for is "If Next record "Artist" field is blank then Merge Next Records "SongTitle" field; If Next record "Artist" field is NOT blank then Do Nothing.
Ive been able to make it look ahead to the next record but the conditions make no difference, particularly the do nothing bit.
I hope this makes sense.
I am quite sure I'm missing something fundamental, so go gently!
Thanks 4 reading,
(LOL apologies, was unaware H.E.L.L would be censored)
Edited by MarkRB, 23 June 2005 - 10:36 AM.