Combining records

[kburns]

I have similar records in one database that need to be combined into one record without using a portal. For example, db1 contains an ID and Name fields. These can have duplicated values (up to five records with the same ID). There are also fields for five other values, but this information was stored in a separate record for each of the five fields. How can I create one record that contains the ID, Name, and values for the five other fields?

[CaelC]

You might want to use a portal then run a script in the new DB that moves (Cut and Paste) the data from the portal and the appropriate related fields into a field in the new DB. Loop that through the new DB and then get rid of the portal and relationship to the old DB.

Of course the new DB needs to have records in it with each of the ID numbers for the portal to work. You can automatically create all the records with serialized ID numbers then after running the loop script above, find and delete the records that don't have any data in the new combined field. All of this will take a little fine tuning but should work well even if there are tens of thousands of records.

Cael.