AnsweredAssumed Answered

Perhaps a Let () function problem

Question asked by pedroble on Sep 16, 2018
Latest reply on Sep 18, 2018 by TobiasLiebhartKoschierSE

I have two tables PORTS and COUNTRY

In the PORTS table there is a PORTS::PortCode field of 5 letters, the first 2 of which represent the COUNTRY::Code

I am trying to use the Let() function to populate PORTS::Country field without luck ...

 

Let (

[

   var_1 = PortCode ;

   var_2 = Left ( var_1 ; 2  ) ;

   var_3 = ports|COUNTRY|| layout::Code ;

   var_3 = var_2

] ;

   ports|COUNTRY|| layout::Country )

 

also tried ...

 

Let (

[

   var_1 = PortCode ;

   var_2 = Left ( var_1 ; 2  ) ;

   var_3 = ports|COUNTRY|| layout::Code

  ] ;

Case (  var_3 = var_2 ;  ports|COUNTRY|| layout::Country ; "unregistered" ) )

 

... which just gives "unregistered"

 

Any help would be most welcome.

Outcomes