Create a new Field with type Calculation.
The Calculation should be:
= Left ( table::Type ; 1 ) & table::ItemNumber & Left ( table::Colour ; 1 ) & table::size
You will need to change the text in Red to whatever you have called your Table and respective fields.
Type Item Number Colour Size SKU T Shirt 1001 Red S T1001RS Jeans 1002 Blue M J1002BM
Thank you for the fast response. This might work well if I all the Types and colors started with different letters but many of types and color start with same letters.
OK, I thought that that would be an issue.
I'd make a Types table with 2 fields: TypeID and Description; and a Colours table with the fields ColourID and Colour.
Enter all of your types with a unique TypeID. Do the same for Colours.
Try and keep the IDs consistent as these will show in the SKUs
Then make a couple of Value Lists: Colours and Types; using values from fields.
The first field should be the ID and the second the description.
Now instead of typing out the type or colour in your products you can select them from a drop down list or popup menu.
Then you can use a slightly different calculation:
= :: & :: & Colours:: & ::
TS T Shirts
Your SKUs will look like: TS1001RDXXXL