AnsweredAssumed Answered

Dynamic Value List referencing a calculation field

Question asked by lourensjoubert on Apr 6, 2018
Latest reply on Apr 6, 2018 by techt

Hi — is there an expert that could shed some light please, I’m stuck (again)…


These two related tables refer:

Screen Shot 2018-04-06 at 11.39.56.png


On a layout based on the jobs table, the IDfkClient field is populated by selecting a client from a dynamic value list. If the list is based on either the ClientFirstName or ClientLastName fields it works as expected.


BUT, I would like to use the ClientFirstNameLastName (CFLN) field instead. And that’s when things fall apart. 


The CFLN field is a calculation that combines the FirstName and the LastName fields as follows: TrimAll ( ClientFirstName & " "  & ClientLastName; 0; 0 )


The CFLN field is indexed.


The calculation itself works as expected on a layout based on the Client table.


So the question is, why does the dynamic value list not work when I use the CFLN field?


Or am I going about this the wrong way altogether?


User stats:

Skills level: Novice

Version: FMPro 16