Easiest way to set up an invoice
I'm using the FM solution "Invoices" for my database, but I'd like to improve it a little.
In the Invoice form, it uses a portal to show the products, although the way to select the products is by selecting the product ID #. That works for a small database with few products, but when there are many (thousands...) that can take a while...
I was thinking about changing it so that we can type in the name (or part of the name) in the "Name" field and then be able to select the one we want. And also create a button on the "Products" form to add the product to the current invoice without changing the layout.
I need a little help on how to set that up...