Import records overwriting my records

[Dchall_San_Antonio]

I got a high priority job a couple weeks ago just as I was starting to use FMP. I enlisted a buddy to help me. He ported the Access db we had been using to an FMP db. Then I modified it ever so slightly. He had made a value list on two fields and I created fields to relate to the values in those fields. I'm not sure if this is part of my problem or not, but it probably should be disclosed before anyone else looks at it. Part of the problem is that we are in a hurry and made two copies of the data we need to input. Although we tried to separate the data, sometimes we both input the same record slightly differently.

Here's the problem. We have found that we cannot import my file into his without losing all the data in those two fields I modified; however, we can import his file into my file and not lose any of the data in those two fields. The problem now is that some of my records are being overwritten by his records. I also tried exporting his to Excel and importing to mine with identical results. If anything I would like all of the possible duplicate records to be in the import, side by side, so I can decide which version of the record I want to keep.

[Dchall_San_Antonio]

I think this is resolved. After you import you only see the records you just imported. I set it to "show all records" and mine are still here. What added to the confusion was that some of the records had been imported by my buddy from my previous work, so it looked like my current work was being overwritten with his. Not so.