Mark Appleby Posted December 19, 2001 Share Posted December 19, 2001 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? Link to comment Share on other sites More sharing options...
Steven H. Blackwell Posted December 19, 2001 Share Posted December 19, 2001 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8187 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now