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

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
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
Photo of RAFAEL VALCARCEL

RAFAEL VALCARCEL

  • 160 Points 100 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
Photo of Chris

Chris, Champion

  • 4,390 Points 4k badge 2x thumb

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?


(Edited)
Photo of RAFAEL VALCARCEL

RAFAEL VALCARCEL

  • 160 Points 100 badge 2x thumb
Thank you very much for your response, I did and it worked perfectely. Thanks again for your response