Topic: Help with table / database schema invoice application
Hello friends,
I am struggling with a table layout for a simple invoice application.
What i basically want to achieve is:
1) When making an invoice (eg in frm_Invoice) the user can select products from a dropdown box, these products were added through a seperate form (eg frm_AddProducts), have fixed names / prices etc > no problem
2) User can also add products directly in the invoice (frm_Invoice) without first adding these products through frm_AddProducts. For example, the user can fill in the text boxes with a description and a price as he chooses and it will be added to the grid. This doesn't get added to the products table for re-use or stock counting later on.
> This is the part i am struggling with. How can i achieve this? Should i add an extra table for this?