Ms Access Data Validatio

[satz]

Hi all,
Here's my query

I have 2 Tables with data namely




Parameters [Project Managers, Group Heads]
User Entry Planning Data [ Project Managers (Lookup From Above Parameters table), Group Head (Here I want the auto value from parameters as soon as the Project manager is selected from User Entry Planning data)


simple example:

Parameters Table:
Project Manager (aaa.bbb,ccc)
Group Head (aba, abb, abc)

User Entry Planning Data:
Project Manager (Lookup) (aaa,bbb,ccc), If selected bbb
Group Head : should return corresponding value abb here.

the question is how to get this output.
when I select I should be able to get group heads name automatically as soon as I select project manager's name in UserEntry Planning data.?

[pbaldy]

How about:

http://www.baldyweb.com/Autofill.htm

[Micron]

is this cross posted https://www.accessforums.net/showthread.php?t=60288