I have a requirement to save previous content within a field as the record is updated. I'm not sure how to go about this.

Here's my db structure:

Table: SPM_Sig_Events

SE_Date_Start (Date/Timne)
SE_Date_End (Date/Time)
SE_Desc
SE_Name
SE_Last_Updated
SE_Report1
SE_Report2

-----------------------

Table: tbl_SPMRecBackups

ID
fld_RecID
fld_BackupDate (Date/Time)
fld_Description (Memo)

I have all of the functions working but have realized that the original content within the SE_Desc field in SPM_Sig_Events is not updated with the new content in tbl_SPMRecBackups, specifically the field, "fld_Description" in the table: tbl_SPMRecBackups. After thinking about it, I wonder if it's possible to do a conditional region on the SPM_Sig_Events table that will HIDE IF there exists a record in tbl_SPMRecBackups that has a corresponding ID (ref_id) that matches the ID in corresponding record from the Table "SPM_Sig_Events."

I appreciate any help at all!

Thanks!