My bar shares space with a dive shop. Quite a few of the dive shop guests will run a tab for their stay. Some may return, others most likely not.
To keep the accounts search clean, I am wondering if it is possible to mark an account as inactive.
With this, the customer search will only show active accounts. Then, should one return, I can mark the account as active to show in search.
If this is possible, how would one go about implementing such a solution?
My thoughts out of the gate would be a column in the Accounts table, “Active” (0/1), and display customer accounts only if Active = 1.
Thanks in advance.