text display in grid obtained from key lookup in another database table

Have table with the following :

prjstaff.EmployeeID = integer -> integer is linked to Employee table
ie (prjstaff.EmployeeID = lookup Employee.EmployeeID)

Employee.EmployeeID is record which contains EmployeeName

Need to display Employee.EmployeName field text in prjstaff grid, and allow user to select EmployeeName from pulldown list but put EmployeeId value back into prjstaff.EmployeeID.

How do I do this. thanks
1 person has
this question