January 6, 2004 at 5:49 am
Hi there,
I am working on a website where I wish to allow users to a make changes to records in a specific table. However, I would like users to only be able to raise change requests and not actually update the table directly. At a later date I would like to view all the change requests raised, see what fields have been changed and updated from / to and either apply them or cancel the changes.
I'm not to sure how best to go about doing this. If anyone can suggest a solution as to how this can be achieved I would be very greatfull.
Thanks in advance...
January 6, 2004 at 9:16 am
Could you have another table and the user inserts into it the changes he/she wants to make. Into this table you would include the unqkey (or some record identifier) from your main table. Then you can view the changes they want to make and be able to join the tables together and 'transfer' the values if you deem them correct???
Another thought: Would it be possible to put constraints on your main table so you do not have to manually verify their changes? If a change a user wants to make agrees with a constraint, then SQL goes ahead with the update...if not, SQL prevents the update?
Michelle
Michelle
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply