I have a form with master/detail relationship, saving to an access database. Now what I'd like to do is to add a record to another table whenever the form is submitted. This record would save basic information to build a revision history for the form, basically who and when.
Database design key fields:
MasterTable: RecordID
DetailTable: ...