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:
- task description
fields table HT:
- installation date
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?