This has probably been asked many times before. I have a sales table with fields invoice number, customer id, date etc. To accomodate multiple sales items per invoice I have a line items table with fields invoice no., item no., and quantity purchased. The relationship between the sales table and the line item table being a one to many relationship connected by invoice number, where many line items can belong to the same invoice.
The question is how do I build a form that that can allow me to input the transactions? Obviously building the form to put in the common invoice information such as customer, date etc is easy, but I would like to be able to input multiple sales items on the same form (as many as required), and get it to write multiple line items in the line item table.
I hope you understand what I mean.
The question is how do I build a form that that can allow me to input the transactions? Obviously building the form to put in the common invoice information such as customer, date etc is easy, but I would like to be able to input multiple sales items on the same form (as many as required), and get it to write multiple line items in the line item table.
I hope you understand what I mean.