I am trying to implement a descriptive SKU (Stock Keeping Unit) to each of my products in a basic product database.
A SKU is an unique identification code for each product, that should help tracking this unit in my inventory.
I have 10 fields in my products table of which 8 are used to form (calculate) the SKU. Based on the information in this fields the SKU-field-calculation should pick the related codes and put it together to a 22-digit-SKU.
|Fields||Example 1||Example 2|
My first idea was to write the SKU calculation as a lot of If-else-commands queued after each other, but I am pretty sure that there must be a more effective way? Like defining the abbreviations somewhere else in the file and just pull them from there? What are your thoughts? Is this a common thing to do in FileMaker?