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. .

	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>