Linking two forms for new data entry

[ahuffman24]

Hi,

I am using Microsoft Access 2016. I have a form that allows users to enter information about a customer order. Each order has various numbers of items, and each of those items can be prdered in quantities of 1 or more. Each item that is ordered also gets an assigned serial number for each quantity ordered (for example, if three of item 1 is ordered, then there are 3 serial numbers linked to that item, one serial number for each order of item 1). My main form (Customer Order Information) has basic customer information boxes that the user can fill as desired (shown below).


If the user needs to add another item to the order, they click the "add another item" button, and another form (Add Item Form) pops up (shown below):




Ideally, this would allow the user to enter another item and the serial numbers corresponding with it. However, this Add Item Form does not seem to be linked to the information entered in the original Customer Order Information form. As you can see in my tables (Customer Order Info Table and Inspection Table), item 2 does not show up in the Customer Order Info Table. In the Inspection Table, item 2 appears, but it does not have the order number, customer name, etc next to it, and it also puts the serial numbers on the next line (shown below).

(Customer Order Info Table)


(Inspection Table)


My question is, how can I link the Add Item Form to the Customer Order Information form so that when a new item is added, it is entered into my tables under one order?

[ahuffman24]

Please ignore the last image that was attached at the end of my post. That should not have been there

[June7]

Why open a popup form? The first form has the same fields. Just move to a new record row. User just has to click on the new record row instead of clicking button.

If you want auto-increment the Item Number for each Order, that will require VBA. Where is the foreign key field for the Order ID?

Not really understanding data structure.

If you want to provide db for analysis, follow instructions at bottom of my post.

[ahuffman24]

@June7, what do you mean by "just move to a new record row?"

[mike60smart]

Hi

A bit baffled by your problem.

If you have a Main Form to display the Customer information and a Subform to enter Orders for the Customer you do not need a popup form to do data input for a new Item.
You would normally just add a new item in the Blank Row shown below the Last Item Entered?

This is what June7 is referring to.

[ahuffman24]

Ah okay I understand now. Thanks!