Forms Help

Hi everyone



I have the following three tables;



tblOrders



OrdID PK,OrdDate,CustomerID



tblMachines



MachineID PK, MachineType



tblMachineTimings



OrdID FK,PK MachineType FKPK MachineTime





Each order has Many MachineType and Each MachineType has used in more than one Orders M:N relationship



I want to create a form for data entry. The desired view would be OrdID and all MachineTypes in one place so that the user can easily input the times for each MachineType related with each Order.



I have attached the database with the query and form I have designed. I need some suggestions what would be the best approach.





I really appreciate any suggestions. thank you in advance

Attached Files

Database.zip (56.6 KB)

Forms Help