Hi all,

i have tried no of thing's to Populated the Relation between the no of form but it's Won't help me ....
pls help me any one my requirement is as follows
i have three table as
Customer,
OrderHeader,
SubOrder,

in Customer table i have two filelds CustomerID,CustomerName
in OrderHeader table i have OrderNbr as primary key and CustomerID as Foreign key and other column also, in SubOrder table i have filed name subOrderNbr as primary key and OrderNbr as foreign key from OrderHeader table using this info i want to genrate form for Select one CustomerName from DropDown and place one order (SubOrder also) for that customer pls send me sample Db using your Filed name and othere info..

thanx and Regards,