Can anyone tell me how I can ensure that people do not delete records from my database but still allow them to delete an unfinished record.

To explain I have a database of credit notes which has certain fileds that must be filled in e.g. ammount.

My problem is I can forsee the users entering a credit note and realising that they do not have all the information then giving up. Maybe delaying the creation for a couple of days. This would not be a desirable way of leaving things.

I can not leave it that someone can delete an old credit note either for obvious reasons.

Has anyone any suggestions?

1. Remove the ability to delete through menu or keyboard commands by setting password privileges or using SecureFM.

2. Set a script to delete a given record. Have the script check for the information required before completing its action.

HTH

Old Advance Man