Forum Discussion

RAFAELVALCARCE1's avatar
RAFAELVALCARCE1
Qrew Trainee
8 years ago

Include same value in all records of a table from another table field

I have one table1 with 100 task that must be carried out on a machine at specific machine running hours. Ex. Task 1, change oil at 2000 Running hours, Task 2, change filter at 1000 running hours. The running hours of the machine are updated in another table, table 2. How can I set a field with remaining hours for accomplishment fpr the 100 task including the calculation with the running hours from the table 2
  • ChrisChris's avatar
    ChrisChris
    Qrew Assistant Captain
    8 years ago

    Can table2 be the parent of the Task table1? From your description, it seems the machine hours recorded in table2 would be related to the maintenance tasks performed in table1 in a parent >> child relationship. Machine table 2 >>>> has many >>>> Tasks table 1.

    Take [Running Hours] in table2 and pass that field along to table 1 as a lookup field. Now, the parent Machine record's [Running Hours] field is present in all tasks related as a child to that table 2 machine record and you can now perform the math in the Task table 1 record.

    Have I understood you correctly?


  • RAFAELVALCARCE1's avatar
    RAFAELVALCARCE1
    Qrew Trainee
    8 years ago
    Thank you very much for your response, I did and it worked perfectely. Thanks again for your response