How to generate item code which is the concatenation of two different attribute from different table?

I'm having first table Category and "Category Name " is the attribute  And having second table Subcategory - "Subcategory Name " is the attribute Having third table Item - "Item code" is the attribute   I have to generate item code by concatenating((first 3 letters of Category Name ) + (first 3 letters of subcategory name))   Eg - Category Name - MANGO         Subcategory Name - APPLE         Item Code - MANAPP    
1 answers

You can create a string variable and use the substring function.


Read more here:


String Function Calls | Mendix Documentation 


substring(A, 3) + substring (B, 3) + substring (C, 3)