I need to merge to sets of records the primary has 60k and is in fmp format the secondary has 16k and is on excel. For convenience sake I'll refer to the fmp set as primary and the excel set as secondary. the primary set has no duplicates in itself neither does the secondary set but there will be when i import the secondary set into the primary . I was thinking i could import the secondary into a separate fmp set then mark all duplicates and separate all marked records into a separate window. If anyone wouldn't mind giving their two cents i'd greatly appreciate it.