setting relationships

[Howard2002]

How do i set the relationships between two files? I know how to create a key field in each table. What I need to know is how do i call fields from the child to display in a list box. example:
parent-tbl
ssn,agn,unit (key fields),name,yrs_serv
child_tbl_1
ssn,agn,unit(key fields),hire_dat,wages,dept_code
child_tbl_2
ssn,agn,unit(key fields),hire_dat,wages,dept_code
child_tbl_3
ssn,agn,unit(key fields),hire_dat,wages,dept_code

My question is how do i call into a list box the fileds form the children?
I hope some one can help me. Oh by the way I am in VFP7

 

[rgbean]

You'd normally create a "parameterized" SELECT for your ListBox RowSource (the parameters being the required key{s}), and then Requery() it whenever you change the Parent record.

Rick