Dear all,

Does anyone know if there's an easy way to merge 2 files? Without recreating the fields from 1 file in 2 file, and importing data.

There are two related files that need to be merged into one big file. Some fields are redundant (same in both) while others are unique. I can recreate unique fields in 1 of the files, and import data into it, but I'm wondering if there's a better way

Thanks

Well, you can omit the non unique records when you do the importing. Or you can make the fields that arn't in the other and import into it.

If i understand what you are saying....

Eric,

I was asking if there's an option to create and import new fields (not records) on the fly, without manually creating unique the fields in one of the files.

Like dragging one file into another (that'd be cool, wouldn't it?).

I am merging file A (bigger file) with file B (smaller file). Since file A already has most of the fields in it, I create the rest of the unique fields in file A, and then do the import into it from file B . File A becomes the joint file.

We're talking more then 100 fields, so it's a pain in the butt to create them all.

So naturally I want to know if there's an easier protocol for merging files.

Thanks for your time.

BB

If you need to put the data from file B into identical fields in file A, whether they currently exist in A or not, sorry to say you'll have to do it the hard way.

You can make it easier on yourself by printing field definitions from file B first; that way, you can compare the printout with the fields in file A in order to speed up creation of needed fields before importing.

Please don't kill the messenger.

I'm calling off the guards, you'll live!

That's exactly what I did, openning both Define Records in both files, cutting and pasting. It just seemed like a dark ages way to do things. On my wish list from next FileMaker 7.0 is the ability to drag-n-drop the file into anither file, creating new fields automatically...

Am I asking too much?

BB

Well, since they've done it with scripts...