Discussions

Expand all | Collapse all

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

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

    Posted 03-19-2017 10:29
    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


  • 2.  RE: Include same value in all records of a table from another table field

    Posted 03-20-2017 12:51

    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?




  • 3.  RE: Include same value in all records of a table from another table field

    Posted 03-20-2017 23:47
    Thank you very much for your response, I did and it worked perfectely. Thanks again for your response