Solved: Populate second field based on selected ref ID - Page 2

Michel_LeBlond · 09-04-2020 01:41 PM

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.

View solution in original post