History Table

[Opid]

Hello all,


I am trying to create a history table that keeps track of all transactions ever processed. The transaction is created from data from a table of tenants and the payment amount entered on the form. I append this data to the transactions table. The problem I am encountering is I am unable to delete a tenant from the tenants table because of its relation to the transactions table. I do not want to remove the tenants transactions. I want the table to be a history of transactions. Any suggestions?

[orange]

This is marked SOLVED, yet there were no responses.
Opid, what is the status?

[Opid]

It was just a simple relationship issue that I figured out. Thanks anyways .