Start a new topic
Deferred

Payees and Categories referential integrity constraints

Would it possible to add a constraint to prevent deletion of payees and categories when they are referenced by transactions?


Consolidating/Purging payees is risky without this constraint.


An alternative implementation could involve adding a count next to the payee/category which indicates how many transactions are referencing the payee/category.

1 Comment

Timothy,

Categories are already like this. You are unable to simply delete a Category if it's used in a transaction - you'll be asked to either merge it with another category or continue deleting it (removing it from all transactions where its used, leaving them with none).

Payees indeed do not have this at the moment - it is on our to-do list for a future update.
Login or Signup to post a comment