We don't mark as deleted either, but have a field which is labeled (is this company no longer used?) but is really inactive .t./.f. For popups all carrier records without a value of .t. in that field are listed.


>>Can you mark those carrier records as 'no longer used?' That is what we do.
>
>I have taken to using datetime stamps for this rather than setting the deleted flag. That way new records don't see deactivated items in picklists etc. and old records still show the old data.
>
>That also allows you to physically delete and pack records that are x days/months/years old. You can deactivate anything at anytime without worry of cascade deletions failing too.
>
>
>>
>>
>>>>Just curious based on your last comments Naomi. We work with insurance records (our app is an agency management system) and we have to retain policy records for 7 years until after the close of all claims, then we can dispose of them. We archive old policy records, claims, and data.
>>>>
>>>In our system we're not deleting records at all. We only make them active/inactive. However, we have some garbage records in our Carriers table. I was thinking we can get rid of them, but then realized we have too many dependencies...