Void Records

[Anuviel]

Not sure if this belongs here - could not find a better place to put it.

Would this be a good way to Void records?

Have a script copy the entire record to an unrelated table and then delete the record from the table in which it was Voided. After deletion the script would make a new record with serial number of the voided record and append Void at the end (Serial_Number & "Void) so that when regular records are browsed through a user can see that a record was Voided and then they can look it up in Voided records table if they need to.

Reason being - when record is Voided it should not affect any calculations when checking all of the records (Show all records) and as I will potentially have couple of people using the solution at the same time (two of which know that AOL = Internet) I am trying to avoid problems that may arise when I try to teach them the meaning of Omit and Show All records and such.

Thanks.,

[mr_vodka]

I would probably still keep them in the same table instead of putting it in a different table. A status field could dicate if it was voided or active.

You could have a script that shows all active records verses voided records. You can use calcs / summary fields to display data for the active projects only if need be.

If this does not work for you and it definately needs to be archived, I would duplicate the data in the record in an archive file. You could clear the data in the active file so it doesnt effect any numbers but the record itself IMHO should not be deleted at all.

[Anuviel]

Got it, so I would duplicate the record in the archive file and then clear the data in the original record leaving the serial numbers intact and setting the status field to Void.

Think that might work for me the best.

thanks