DATA VALIDATION CONTROL BOTH WAYS PARENT LIST Vs CHILD LIST

[abuharvey]

Please find attached sheet i need data validation as described above and in sheets


thanks in advance. .
[TABLE="width: 973"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD]USER SELECT PROJECT CODE (TO BE RESTRICTED BY PER DEFINED LIST AS SHOWN BELOW)[/TD]
[TD]ONCE SELECT PROJECT CODE THIS SHOULD DISPLY THE PROJECT NAME[/TD]
[TD]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[/TD]
[TD]ONCE ITEM CODE SELECTED ITEM DESCRIPTION SHOULD BE DISPLY HERE[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Assigned To[/TD]
[TD]Project Code[/TD]
[TD]Project[/TD]
[TD]Item Code[/TD]
[TD]Items[/TD]
[TD]Qty[/TD]
[TD]Unit[/TD]
[/TR]
[TR]
[TD]Daniel[/TD]
[TD]J1043[/TD]
[TD]L&T[/TD]
[TD]MAS-01[/TD]
[TD]Mashrabia[/TD]
[TD]4[/TD]
[TD]RM[/TD]
[/TR]
[TR]
[TD]Nagalingam[/TD]
[TD]J1043[/TD]
[TD]L&T[/TD]
[TD]BAL-01[/TD]
[TD]Balustrade[/TD]
[TD]6[/TD]
[TD]NOS[/TD]
[/TR]
[TR]
[TD]Melvey[/TD]
[TD]J1048[/TD]
[TD]Parsons[/TD]
[TD]RST-01[/TD]
[TD]Railing Stair[/TD]
[TD]8[/TD]
[TD]RM[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="colspan: 2"]PARENT LIST[/TD]
[TD="colspan: 3"]THIS IS THE CHILD / DEPENDENT LIST[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Project Code[/TD]
[TD]Project[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1043[/TD]
[TD]L&T[/TD]
[TD]J1043[/TD]
[TD]MAS-01[/TD]
[TD]Mashrabia[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1036[/TD]
[TD]Vijai Cements[/TD]
[TD] [/TD]
[TD]COR-01[/TD]
[TD]Cornice[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1048[/TD]
[TD]Parsons[/TD]
[TD] [/TD]
[TD]BAL-01[/TD]
[TD]Balustrade[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1061[/TD]
[TD]Reyana Builder[/TD]
[TD]J1048[/TD]
[TD]RST-01[/TD]
[TD]Railing Stair[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1064[/TD]
[TD]Prism Cons[/TD]
[TD] [/TD]
[TD]PCC-01[/TD]
[TD]Precast CC[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1050[/TD]
[TD]Aliens[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1051[/TD]
[TD]Big C [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1065[/TD]
[TD]R and D[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1066[/TD]
[TD]Ramco[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]J1067[/TD]
[TD]TATA[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]