Bring fields values in a repeating context to another one

M

masker

Hi!
First of all I'm not a programmer, so if there will be a need of code
writing, please explain it in details and step by step

What I have here is two Repeating Tables;

- the first one let it be "VoidTypes" and contains four fields: "Type",
"Width", "Height" & "Depth"
- the second one is "Zones" contains three fields: "ZoneID", "Voide",
"TypeQty", "TotalWidth" & "TotalVoidArea"
and what I'm trying to do is:
(1) Make the form user able to insert however the "VoidTypes" he needs,
(2) In "Zones", as he creats new rows, he select one or more "Type" from the
"Voide" field,
(3) Once he selected the "Type" and insert the quantity in "TypeQty" field;
in the "TotalWidth" & "TotalVoidArea" the values appear according to the
values he previously inserted in "Width", "Height" & "Depth"

Actually, I don't have problems in all of (1) and (2). But in (3) how can I
bind the 3 values of "Width", "Height" & "Depth" with the selected "Voide"
item?
I hope that my problem is clear to you and I'll appreciate any help!
 
Top