I still don't see why you can't just update the records. Can you post an example of your tables?

>To clarify... I might have one record in a product table that is for a guitar and then there is a related 'variant' table that holds the sku number, color, etc for each modification of that guitar.
>
>If that one guitar changes I was going to delete the one record in the product table and possibly 10 records out of the variant table (for example) and then readd the one guitar and 10 variants. The other non-related records would not be deleted and readded.
>
>So what do you think now? Do you think this is acceptable?