export one header and many client records

[tawatana]

Hi all,

this is another problem i'm having (might be easier than the other one!). When i export the records to the text file, i need to export ONE header record - which has several fields - followed by each client record. The way i currently have things set up is that the header record is at the beginning of each client record like this:

header record : client record

header record : client record

header record : client record

etc..

but it needs to be like this

header record

client record

client record

client record

etc...

I know that this is because i have the header as the same record as each client (different layouts) but i'm not sure how to things this other way. i'm using the scriptmaker to attempt all this.

thanks

brian

[LiveOak]

The only way that comes to mind is to create another file and use a looping script to build the records you wish to export by putting either header information or client information in the field(s) of this new file. The actual "export" would then be performed from this new file. The same technique is used to create reports which defy all other methods. -bd