I am running a company and contact database. Due to the nature of my app, I need to have duplicate records. Whenever I want need to do a mass import, I need to make the parent object (in my case company and company name field) unique in order to attach those contacts to the duplicate companies that I am importing. For example:

      - Corporation Inc. - FIRST RECORD

      - _Corporation Inc. - DUPLICATE RECORD

After my import, I need to remove "_" manually. In some cases there are 100s of records. It is a painful process needless to say. Is anyone aware of any workaround?

Any suggestion would be much appreciated.

Thank you,

B