Need Quick Help

[Mark Appleby]

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?

[Steven H. Blackwell]

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