How to generate item code which is the concatenation of two different attribute from different table?
0
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
asked
Komal Chandolure
1 answers
0
You can create a string variable and use the substring function.