In the attached I have updated the database from my previous thread, but am really still having the same issue, just in a different way. In the Sponsor Request Form, I have to update subforms with data from previous subform entries. For example, I enter in Items in the Order Details subform. Then I go to update the Product Details Subform, but have to provide the Order Details (PK #) in order to save the record, or I get the error "You cannot add or change a record because a related record is required in table "Order_Details_Table"" Once I enter the number the record will save successfully. The same thing happens when I enter data in the Ship Details Subform, but it needs the Product Details (PK#).
Can you please provide guidance on how to resolve.
Thanks!