Solved: Look up expression for ref column - Page 2

Phong_Lam1 · 12-07-2021 09:30 AM

Hi all, I have table “Client” ,table “Potential Client” and table “People” , Table “People” referenced to table “Client” ,and table “Potential Client”

Is there a way when I add new “People” in form,when we choose “Potential Client ID” (a reference column), the other column [Client ID] (also ref column with “People” table, will automatic filled (just as dereference) when “Potential Client ID” is [Client ID] (potential client become client ).

I think about to have a look up expression for [Client ID]. But dont know how to do.

Thanks !

Suvrutt_Gurjar

As per understanding, finding a key that is unique in a table from other values through LOOKUP() could be an issue because there is a possibility of other values being repeated in a table.

Anyway, you may wish to try the below.

Please create a column in the "People " table called [Potential Client Name] with the expression [Potential Client ID].[Potemtial Client Name]

Then the lookup for [Client ID] in the “People” table can be

LOOKUP([_THISROW].[Potential Client Name], “Client”, “Client Name” , “Client ID”)

View solution in original post