AnsweredAssumed Answered

Set field according to matching fields

Question asked by scheip22 on Dec 11, 2016
Latest reply on Dec 11, 2016 by erolst

Hi guys,


Could anyone help me with following problem please. I think it is not that difficult, but I don't see it.


I've two lay-outs:

- AMP: Maintenance tasks (table AMP)

- HT: component specification (table HT)


fields table AMP:

- tasknumber

- Interval

- task description


fields table HT:

- component

- installation date

- Interval

- tasknumber



Lay-out AMP, summarises all maintenance tasks of a machine.

All maintenance tasks have a different tasknumber (AMP::tasknumber) with a defined Interval (AMP::Interval)


The other lay-out visualises all components of the machine. By importing a component the user has to type the related tasknumber for this component. By adding this tasknumber, the Interval have to be set automatically according to the predefined maintenance tasks in the maintenance  summary.


HT::Interval = If HT::tasknumber equals AMP::tasknumber; get AMP::interval of the record that contains the defined AMP::tasknumber (which is equal to HT::tasknumber).


How could I do this with a calculation/script?


Many Thanks!