Combining column values to create unique key
I have a table with four (4) columns: 1.SWOT ID 2.SWOT Name (to be entered by user)
3.SWOT categories (Values: Strengths, Weaknesses, Opportunities, Threats) 4.PESTEL categories (Values: Political, Economic, Socio-economic…Legal)
I want the SWOT ID computed as follows: [1st 3 characters of SWOT Category value] + [1st 3 characters of PESTEL Categories value ] + Record Number
So for example, if the values selected for record #1 was strengths, political I would like the ID computed as follows:
[ STR ] + [POL] +1 = STRPOL1
How would I go about implementing this?