In my base, I have 2-tables. The first table contains all of my primary data—the second table with additional data related to my first table.

In table-1, I have a column named “month number”, which means a number will represent a month; i.e. 2 = February or 12 = December etc.

It looks like this:

Month Number

1

5

8

9

In table 2, I have a column named “Month”, with all the months of the year in their own lines.

Example:

JAN

FEB

MAR

Next to that column, I have a column named “Month Number.” Which obviously resulted in having numbers 1 to 12, next to the months of the year.

In my first table, next to the column named “Month Number” I’ve added a column called “Month_Name”. In this column, I want the column to identify that a number represents a specific month name and fill in the column with the corresponding name.

For example:

If 4 = APR, then I want APR to appear in the “Month_Name” column next to it’s “Month Number” column.

So it will look like this:

Month Number

4

Month_Name

April

Your help will be highly appreciated.

Thanks