I am trying to fill a couple of fields from a parent table with corresponding values from a child table upon selection of a category.
In the parent table layout, I have 4 fields (Category, Object 1, Object3and4 and Object6). Category is a value list based from ValueName in the child table. If I select a value from the Category list, Object1 and Object6 will display corresponding values (Value1 and Value6) from the child table. Object3and4 also does the same but as a calculation (difference) from Value3 and Value4 fields also from the child table.
I tested making a case statement and it worked. Only to realise later that the values in the child table are changeable. Now I'm stuck with what function or method to use to solve this.
Attached is a sample file.
Many thanks in advance for any help.