Populate second field based on selected ref ID

[Michel_LeBlond]

Hi ,
I have seen something like what I am trying to accomplish in one of the samples but cannot find it.

I want the email address to update when I pick a client in the drop down. As per the images below.

I have tried various lookups and selects but no luck so far.

[OptimiX_XcrY]

I think the formula for useremail is [clientid].[useremail] as initial value or as you please. I suppose that in the ref table , the name of the email column is useremail too.

[Steve]

For reference:

[Michel_LeBlond]

Thanks. Easy as pie. Simple dot notation for the objects.

[Michel_LeBlond]

Thanks Steve. The bit about chaining with a virtual column is good to know.