I have a general design/philosophy question. If trying to manage a sync of data between the line items on a transaction and a sublist of custom records that should always be in sync with those line items. Is it better to use a script that would delete all custom records and re-create with the latest data everytime the record is edited< OR Try and have the script manage some sort of review of the custom records and add/update/delete as necessary to keep all the data in sync?

I've opted to delete and recreate in the past. too many ways to mess up the other way, unless its super simple I figured it was just safer to wipe and start fresh

save the old custom record and do edits on it so you have history

what battk said

Thanks everyone. @battk and @Fred Pope one thought was performance. It seems like deleting and recreating would be a little better for performance (using a UE script). Rather than scanning all linies and updating then scanning all custom records and removign/updating if lines are removed. But maybe is a negligible difference. What do you think?

A Custom Child Record Sublist is the performant option recommended by the SAFE guide.