At 10:21 2017-12-29, mbsoftwaresolutions@mbsoftwaresolutions.com wrote:

On 2017-12-29 12:18, Gene Wirchenko wrote:

[snip]

...

 I added an archive/dearchive to my client billing app years ago.

The tables that we were concerned about were the work transaction table and the invoice table. Archive up to a selected date. It is ad hoc.

THAT'S what I'm talking about. I'll be this feature really gives your app twice the shelf-life too since it can basically hold almost up to TWICE as much as a single maximum with this design!

Nice touch.

Another thing to take away from this is to listen to the users. My boss suggested this. This was something that could be implemented quickly and easily, too.

Sincerely,

Gene Wirchenko