I'm making a form for speeding up the process of creating commercial invoices. I attached screenshots for visualization.
The invoice entry form has an underlying table and each line item has it's own field. (IE: Line Item 1, Line Item 2, etc). My goal is that when you click the pencil button next to the corresponding line item, it will pull up another form (which is based on a select query) that allows the user to enter a SKU number and the description of the product is pre-populated. From there I want the user to be able to click "Add Line Item" to add the product details into the appropriate field (ie: Line Item 1)
How can I achieve this?
I barely know anything about coding so please be as descriptive and simple as possible.