Populate second field based on selected ref ID

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.

Form

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.

2 Likes

For reference:

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

1 Like

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

1 Like