Hi,

could someone offer some advice?

I have a karaoke database consisting of two tables. One table for the CD titles and the other table for the track listings. They have a relationship so I can create a report based on the cd title with the relevant track listings.

Then I will add a common header to the report and then print to file, each and every record to a separate file, taking it's name from the cd title field.

The reason for doing it this way is that I want to create a file that is acceptable for a Local Freedb database file that I can ID3 tag locally on my pc (NOT for submission to freedb.org) as such:

# xmcd

#

# Track frame offsets:

#	150

#	210627

#

# Disc length: 2952 seconds

#

# Revision: 1

# Submitted via: xmcd 2.0

#

DISCID=270b8617

DTITLE=Franske Stemninger / Con Spirito

DYEAR=1981

DGENRE=Classical

TTITLE0=Mille regretz de vous abandonner

TTITLE1=L'arche de no

EXTD=Copyright © 1981 MCA Records Inc.nManufactured f

EXTD=or MCA Records Inc.

EXTT0=Des PreznYez

EXTT1=Schmitt: A contre-voix n(excerpt)

PLAYORDER=

This will be the header information:

# xmcd

#

# Track frame offsets:

#	150

#	210627

#

# Disc length: 2952 seconds

#

# Revision: 1

# Submitted via: xmcd 2.0

#

and the body will come from the database as:

DISCID=270b8617

DTITLE=Franske Stemninger / Con Spirito

DYEAR=1981

DGENRE=Classical

TTITLE0=Mille regretz de vous abandonner

TTITLE1=L'arche de no

EXTD=Copyright © 1981 MCA Records Inc.nManufactured f

EXTD=or MCA Records Inc.

EXTT0=Des PreznYez

EXTT1=Schmitt: A contre-voix n(excerpt)

PLAYORDER=

I can't think of any other way of doing this so I am stumped about the way to print to file for each and every cd title as a separate file in filemaker 9.

Any help appreciated.

Thank you

You could do it via this:

http://www.kevinfrank.com/download/kf-fast-summary.zip

....and then, when the stuff is collected, via this:

http://www.filemaker.com/help/Script-Steps54.html

--sd