LinkedIn
Twitter
Hi support,
I’m build a Production application.
The shop supervisor does a floor tour in the morning where he audits every department.
For every product that the department has done so far, he has to enter:
• Product #
• Quantity
Then, the apps calculates the Quantity * Product standard time (that we have in another table).
My issue is that sometimes the department has done several different part #. Therefore, I’ve built another table to enter the information I need for every part as:
• Product #
• Quantity
• Planned time (Quantity * Standard time of the product)
I’ve also set this reference as “Is a part of” so that for every floor tour, we could see as the image below the part production.
Now the data I’m trying to get is the sum of the “Planned time”. As the Floor tour form is not saved yet, I cannot search in the database for my data.
Can you please help me on how I could get this data?
