Please find attached sheet i need data validation as described above and in sheets
thanks in advance. .
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
thanks in advance. .
USER SELECT PROJECT CODE (TO BE RESTRICTED BY PER DEFINED LIST AS SHOWN BELOW) | ONCE SELECT PROJECT CODE THIS SHOULD DISPLY THE PROJECT NAME | AFTER SELECT THE PROJECT CODE THIS ITEM CODE ALSO TO BE SELECTED CONTROLLED BY DEFINED ITEMS IN CHILD LIST ONCE THE PROJECT CODE CHANGED THAT SHOULD REFLECT HERE | ONCE ITEM CODE SELECTED ITEM DESCRIPTION SHOULD BE DISPLY HERE | |||
Assigned To | Project Code | Project | Item Code | Items | Qty | Unit |
Daniel | J1043 | L&T | MAS-01 | Mashrabia | 4 | RM |
Nagalingam | J1043 | L&T | BAL-01 | Balustrade | 6 | NOS |
Melvey | J1048 | Parsons | RST-01 | Railing Stair | 8 | RM |
PARENT LIST | THIS IS THE CHILD / DEPENDENT LIST | |||||
Project Code | Project | |||||
J1043 | L&T | J1043 | MAS-01 | Mashrabia | ||
J1036 | Vijai Cements | COR-01 | Cornice | |||
J1048 | Parsons | BAL-01 | Balustrade | |||
J1061 | Reyana Builder | J1048 | RST-01 | Railing Stair | ||
J1064 | Prism Cons | PCC-01 | Precast CC | |||
J1050 | Aliens | |||||
J1051 | Big C | |||||
J1065 | R and D | |||||
J1066 | Ramco | |||||
J1067 | TATA |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>