Hi all,
A bit of help if someone has a moment.
If you launch the "Company" form in the attached db (examples are better to work with than explanation) you can see it is 1 form with 2 subforms.
If you double-click on one of the names in the Employees subform a pop-up form "NewOrders" is loaded. However, once the data has been entered and the close button has "OnClick" written the data to the Orders table a 2 problems occur.
1. The "order" is duplicated in the Orders table
2. The Orderssubform isn't requerying.
I have checked the relationships and the Master-Child field settings but can't work it out. Can someone help?
A bit of help if someone has a moment.
If you launch the "Company" form in the attached db (examples are better to work with than explanation) you can see it is 1 form with 2 subforms.
If you double-click on one of the names in the Employees subform a pop-up form "NewOrders" is loaded. However, once the data has been entered and the close button has "OnClick" written the data to the Orders table a 2 problems occur.
1. The "order" is duplicated in the Orders table
2. The Orderssubform isn't requerying.
I have checked the relationships and the Master-Child field settings but can't work it out. Can someone help?