Good Evening,

Thank you all for your previous attempts to help.  I realized I had fundamental relational issues and have attempted to fix them and am now finding moderate success.

I fashioned my attempt after the order/invoice videos and am making progress on the form to take the part of the manual table entry

I will post screen caps after this is approved however the questions are:

1: I have a single form with two subforms linked to the freightorder_idt and the freightorderdetails_idt  The problem I am having is, everything seems to be working properly.  I can add records and save them however the freightorder_id is not being populated into that field in the freightorderdetails_idt.  I think that is a fundamental relational issue, or perhaps the way I have built the form but ideally:

You would enter the customer and order information and that would generate a primary autonumbered key and then you would use the bottom form to populate the orderdetails table pulling the orderid from the upper part of the form.

Thank you

Shane