fetching multiple records

hi frds
my problem is ...
actually i am having two textitem in D2k both are from diff table but has a common column. and for the first textitem i have an LOV and selecting an value from lov and entering it has to display the second textitem. actualy for the first textitem for one value we have four record values for second textitem.for eg . consider managerid as first textitem which has one record and for each manager there will be four employees under him ...,so the second textitem will be having 4 records and it has to display four employees in secong tectitem when we select 1 managerid in first textitem from lov. how to do .....i tried using cursors but where and in which trigger i have to write the code pls guide me .
thank u