Look up fields in forms

[Lauralou]

Hi

I think this is fairly easy but I'm totally stumped!

I have a table with my staff info in it together with a staffID as the primary key. I have another table where I will be recording other staff related things which has a relationship set up between the staffID fields. I want a form set up so that I type in the staffID in a form (to be logged in the 2nd table) and it automatically brings up the persons name from the first table. Is there a simple way of doing this?

Thanks so much

Laura

 

[Andrew Fergus]

Hi Laura
Yes this can be done. Your form must be based on a query that includes both tables. On the form, make the staff id a combo box and untick the enable property of the name box. When you select an employee id their name will show on the form.
HTH, Andrew.