Data Validation in Access

[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.

all this should be answered for Access not excel

[ranman256]

is there a question?

[satz]

Yes on the top ive mentioned here's my query. as in the examples I gave, I want to get the output using access.

[orange]

satz,

It appears you are trying to be efficient and brief.
However, we don't know you , your business or your expertise.
How about stepping back and describing what you really want to do with an example showing before data and the expected result from that same data.
Clarity in communications is key to getting a focused answer.

Also, could you please tell readers what you have tried, and the results you obtained?

[Micron]

cross posted? https://www.accessforums.net/showthread.php?t=60312