• In theory that sounds fine, in practice not so much:

    Say I have Bull1 associated with Cust1, Cust2, Cust3, Cust4, Cust5. User now opens a UI screen with cust_checkboxes checked for these customers. User then unchecks Cust2 and Cust5. I need to reflect this change in the child table.

    So...

    DELETE FROM Bull_to_Cust_tbl WHERE BullID = Bull1

    for each checked value in cust_checkboxes

    INSERT INTO Bull_to_Cust_tbl ...

    end for

    That's alot of inserts versus a single insert to a main bulletin table with Cust# concatenated. Or is this a false issue - lotsa insert no big deal?