Auto fill a field

[NameDuJour]

I am using an Access DB to provide data to use in drop down lists. It is
pulling from a two field table. The first field is the process number and the
second field is the process owner. The first drop list will show the process
numbers but I would like to show the process owner in a separate field based
on the process number chosen in the drop down list. What type of filed should
I use for the process owner and how do I populate it based on the process
number chosen?

Thanks...

 

[NameDuJour]

Super duper thanks.

----------

set up a rule on the Process Number dropdown to set the value of the Process
Owner field.

the formula will need to use a filter to return the ProcessOwner WHERE
ProcessNumber = the value in the process number field in your form.

hope this helps

Ed