Jump to content

Merge Two Records


This topic is 5682 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi there,

I have a database of recruits that contain personal information and tournament and recruiting contact tables accessed by portals. I have written a script to detect duplicates based on name, high school, and state.

The problem that I am having is writing a script to merge the duplicate records. I want to merge them because the first record might have one tournament and the other record might have another, if something happened during import.

I can't seem to find a way to have access to the fields for both at the same time. Does anyone have any ideas? Thank you.

-Cam

Link to comment
Share on other sites

Here's a script that deletes duplicates but merges the child records into the original. The check for duplicate records is very basic, since you already have that worked, merely checking whether the name is the same. I concentrated on the portion of the script to merge the duplicate record child records.

MERGE.fp7.zip

Link to comment
Share on other sites

That looks like it is going to work great for the tournaments and recruit contacts!

Would I need to use variables to merge the information in the main information table (i.e., phone, email, addr)? I can't think of any other way to access information in two main records.

Thanks.

Link to comment
Share on other sites

This topic is 5682 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.