Creating audit records based off Active Contract records

I suggest creating a saved table to table import to Import Active Contract Records into the Audit table.  Map the Record ID# field into the field [Related Contract].

Once you have that setup and tested, you can use an "Automation" run this import on a schedule.