Why do you not just put all the data in the same table and use a field to indicate which is which?

to be honest I am not sure how I would incorporate it all into 1 table.  the wirelistchangelogT gets it's data from
Private Sub Form_BeforeUpdate(Cancel As Integer)
    If Me.Dirty Then
        If MsgBox("Data has changed!  Save changes?", vbYesNoCancel) <> vbYes Then
            Me.Undo
            Cancel = True
            Exit Sub
        End If
    End If
    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO WirelistChangeLogT Select * FROM WirelistT " & "WHERE ID=" & ID
    DoCmd.SetWarnings True
End Sub

and the logT gets it's data from the module
Public Sub Logit(Description As String, Notes As String)
    DoCmd.SetWarnings False
    DoCmd.RunSQL "INSERT INTO LogT (Description, Notes, User) " & "VALUES (""" & Description & """, """ & Notes & """,""" & TempVars("UserName") & """)"
    DoCmd.SetWarnings True
    
End Sub
then of course the wirelistT is where all the regular data is stored
I am not sure how I could incorporate that all into 1 table