Hi there,
I am trying to solve a tricky problem without success.
Created a rather simple template for a technical report.
Much of the cells must be filled “by hand” from the report’s creator, but just one field should be filled by the matching key-value in a list.
I try to explain.
Imagine you have two empty cells in the table of the report and a list (i.e. file) that contains the matching key-value type:
1: Spouse not legally separated
2: Spouse actually separate
3: Natural children recognized
4: Adoptive Children
5: Entrusted children
6: Spouse legally and effectively separate
7: Grandchildren cohabiting
8: Parents cohabiting
…
I would like to put only the number in the first cell (eg 1 or 4) and have the second cell filled with the matching value picked from the list – file or something else – (eg ‘spouse not legally separated’, or ‘adoptive children’), without having to type directly the value by in hand.
How can I fix?
Thanks in advance