I have used AREV 3.0 for years, and have the following problem. I have two data file, one with a multi (3) field key, and one with a automated counter as a key (this second file contains the same fields as the file with the 3 field key and is otherwise identifcal).

I would like to combine these files into one, with a multi (3) field key. How could I do this? I can export both files to dbase format and merge them, and then import the combined file back into AREV, but when I do this I can not get it to allow me to have a multi-field key.

I could try and set up an environmental bond to the merged dbase file (I also use a old dbase report software package to run reports, so this would have some benefits), but I have never been able to figure out how to set up an "env. bond".

Any assistance would be greatly appreciated.

Mark Hoffman

Just write an RBasic program that reads the sequential no. keyed file, creates the multipart id and writes the record out to where ever you want with the new multipart id.

Hopefully there is some logic as to how the multipart keys are created.

Example:

open "SOURCE" to source_fv then

 open "TARGET" to target_fv then

    select source_fv

    loop

       readnext seqid else stop

       read @record from source_fv,seqid then

          @id=something:'*':somethingelse:'*':whatever

          write @record on target_fv,@id

       end

    repeat

 end

end

Note: writing out with @record and @id will update indexes, if any, and can significantly slow down the process.

View this thread on the forum...