hello everyone,
i m working on project in that the key concept is to transfer water from one location to other location. first of all we have many system, sub-system, units, and tanks. here i domenstrate the condition of this plant.
a. SYSTEM A
i. SUB-SYSTEM X
Tank format:- UNIT - Tank_No. - TK - Sl_No.
I. 1-7313-TK-1
II. 1-7313-TK-2
III. 1-7313-TK-3
IV. 2-7313-TK-1
V. 2-7313-TK-2
VI. 2-7313-TK-3
ii. SUB-SYSTEM Y
Similar Tanks with different name.
iii. SUB-SYSTEM Z

here system, sub-system, unit decides the location of tanks. it not necessary that SYSTEM B should have similar sub-system, unit and tanks. it can vary.

i want to move water from one system tank to other system tank. before draining water from tank. i wil first take the reading like Initial_Level, Final_Level, Total_Qty., etc and put those reading into to database using textboxes. Similarly i wil perform this operation at destination tanks.

now the problem is if i want to move water from multiple source tanks to multiple destination tanks. i don't know how to perform this task.

can anyone help please?