I would like to create a new database for invoicing purpose.
I saw that to do that you would create the following tables: products , invoices, lineItems
I have a portal for line items in my invoice form. I can add products in my line items portal via a drop down list but if you have a lot of products in your database this will not be really easy to find and select the product you want to add in your portal.
Is there an easy way / samples to look for my products with some wildcard characters and to add one in the portal.
Help please :-)