G'day,
I have a dbase with 5 tables N_Customers, N_Orders, N_Products, N_Timequoted and Employees.
I am trying to build a form showing Customer Name, a subform1 with list of Orders and then for each order a subform "Products" with the list of the parts used and finally subform3 "Labour" with the name of the tradesperson and the hours expended on that order number.
It all seems to work if I increment customer record in that all 3 subforms update their data. However if I increment the record for the Orders subform the Products subform updates and shows the parts used on each order as expected, however the Labour subform does not update with name of the employee and the hours worked.
I suspect I need refresh the Labour subform whenever the Order subform record is incremented or changed. But I am not sure how to trigger that event, Any ideas or suggestions would be greatly appreciated.
I have attached a cut down copy of the dBase. :banghead:
I have a dbase with 5 tables N_Customers, N_Orders, N_Products, N_Timequoted and Employees.
I am trying to build a form showing Customer Name, a subform1 with list of Orders and then for each order a subform "Products" with the list of the parts used and finally subform3 "Labour" with the name of the tradesperson and the hours expended on that order number.
It all seems to work if I increment customer record in that all 3 subforms update their data. However if I increment the record for the Orders subform the Products subform updates and shows the parts used on each order as expected, however the Labour subform does not update with name of the employee and the hours worked.
I suspect I need refresh the Labour subform whenever the Order subform record is incremented or changed. But I am not sure how to trigger that event, Any ideas or suggestions would be greatly appreciated.
I have attached a cut down copy of the dBase. :banghead: