I have a table that gets updated each night. I will update or insert into the tables depending on if there is a record there or not. All data will be overwritten with the exception of the ID field which is randomly generated and the MattersID field. On my first pass I set QMBDIT, QMCorp and QMLLC to 'N'. Then I look in the Matters table and decide what fields will be changed to 'Y'. The MattersScheduling.ID is not stored anywhere else.
Here is my table: MattersScheduling
ID - Randomly generated
MattersID - the ID field of the Matters table
QMBDIT - Will be Y or N depending on what is checked in the Matters table
QMCorp - Will be Y or N depending on what is checked in the Matters table
QMLLC - Will be Y or N depending on what is checked in the Matters table
1) Would it be better practice to set all necessary fields to 'N' and UPDATE/INSERT?
2) Delete all entries in the MattersScheduling and do an INSERT?
Thank you for your help.