I am using SPT to create a table for a report. Initially I find a list of assemblies that match a certain job number. This I scan through each assy breaking them down to detail parts. This may take several sub scans for assemblies of assemblies. Each of these details is written to a temporary table. Now my problem is some assemblies have common parts. What is the best way to make sure my insert sql statements only write one record per detail number?