Tracking Roster Additions and Deletions

[Termanic]

I have a roster which is a portal of Classes and the students assigned to them. The roster is added to AND deleted from sometimes on a daily basis -- kids add or drop the classes.

Rather than printing out ALL of the new rosters with the changes for the teachers, I would like to only find the rosters which have been added to or deleted from.

I have been able to find the "Added to" rosters by using a Date Modified field ... but to find the rosters which have had Deletions made to them ... YUCK! No success!!

Suggestions/Solutions welcome!

[kennedy]

One approach: make "deletion" of a student just mark the record as deleted on date X, but not actually delete the record. Have your various portals filter out the deleted records. But other things can see when things were deleted (like a calculation field on the roster computing a last-modified date).

Another approach: script the deletion of students from a roster such that you can modify a last-modified date field on the roster to reflect that the roster changed on that date.

HTH.