I'm creating a Document Control Database.
The Database essentially is 2 tables. 1 Document Details
2 Version Control
I want to click a button, the control adds todays date to the date field when the update button was clicked.
The button is on a continuous form in the footer. the query filters the records to show all the historic versions for the document being viewed.
I'm not sure how to code the update.
My fields in the version control table are:
PK
FK
DocumentAmendment
Amendedby
DateAmended
Version
DateUpdated
If the query form shows 4 versions, I want to add the new record, I can do that, but I need to set the DateUpdated for record 4 to todays date.
Any pointers or methods I should use would be helpful.