I have developed a small db (MS Acess 2007) handling Patient Filing and Invoicing.
As with db’s, it is never complete as users' needs always change for more functionality, felxibility and ease of use.
The invoicing is setup as follow:
I have two tables:
1 - Main Table: Invoice (InvoiceID =...