Skip to main content
Question

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

  • March 19, 2017
  • 0 replies
  • 43 views
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
      This topic has been closed for replies.

      • ChrisChris
      • Registered
      • March 20, 2017

      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?


      Thank you very much for your response, I did and it worked perfectely. Thanks again for your response
      Terms & ConditionsAccessibility statement