Creating a new table from one column to make a M:M relationship

Hi all,

Another issue, thanks for your help.

I have one column / field in my main table that's a comma list value - for example:

Person ID
Employment Status

Employment Status is either one value or 2: "employed, part time"

It seems like it's up to 2 values, I can't see more than 2.

If I just split the column creating employment status 1, employment status 2; the report is not right.

Do I need to create a table for employment status, and then do a M:M table in the middle? Or is there a way round using the 2 columns, but reporting as 1?

In the report I just need the count for each value:
Employed
Part time
Unemployed

The total would be higher than the total number of people since one person can have more than one value, but that's ok.

Any ideas?

Thank you so much,

Grazi