AnsweredAssumed Answered

Advanced unique character generator

Question asked by amiranda on Mar 24, 2016
Latest reply on Mar 24, 2016 by beverly

Hi All

 

I'm not a FMP expert by any stretch of the imagination. I think this request is simple but could be very wrong. Please let me know if this is confusing:

 

The objective: Create a unique "style number" It will be created by adding  an established naming convention with an auto generated two character code. The style number must be exactly 4 characters.

 

Table 1

Department Information: This table contains a department description and a manually generated two character code.

Example:    Field1: Fashion

                    Field 2:FM (unique, manually created)

 

Table 2:

Item Creation: This is where the end user will obtain the unique, incremental value. Due to limited number of possible combinations, the two trailing characters cannot be unique -however, the entire combination must be unique.

Example:

            Record 1

              Field 1: FM - (can be a dropdown from table 1)

              Field 2: 01 - (This should be auto generated)

              Field 3:  FM01 Output/Assigned number


              Record 2

              Field 1: FM - (can be a dropdown from table 1)

              Field 2: 02 - (This should be auto generated)

              Field 3:  FM02 Output/Assigned number

 

               Record 3:

              Field 1: AL - (can be a dropdown from table 1)

              Field 2: 01 - (This should be auto generated)

              Field 3:  AL01 Output/Assigned number


Output:, FM02, FM03, AL01, AL02, FM04, AL03, etc...

 

Important, The solution must assign alpha numeric "Item codes" This gives us upwards of 1200 combinations per style number vs just 99.

 

Any input would be greatly appreciated.

Outcomes