Suggestions for archiving or closing records
In my current application I am building for the purpose of tracking Assets, their monthly rental rates, rental charges for each/month, and monthly invoices for each client. Currently the application...
Forum Discussion
You can write a Pipeline that duplicates the data in a new table and then deletes the old records. You need to really think through all your reporting scenarios to make sure that you are covered.
Another answer would be to push all of this data including the relationships out to a real SQL DB. That you can really query it for unique purposes, push to an AI model and so on.