HW Something about commas and multiple things in one field idrk

[plshelpmewithcommas]

So I admittedly dont pay attention enough in class and have a HW assignment due tonight on a database which i've figured my way through up until now.




Basically my issue is I have a thing whith an area of expertise for a job/contract that has area type of expertise in it and a desc. of that area of expertise.
The problem is some jobs require more than one area of expertise and contractors have more than one area, in the excel data that I have to convert its separated by a comma, so I just entered it by hand with a comma separating the expertise code (three letter abbreviation, youll see in the attachments).


When I try to make a relationship between the two areas it obviously doesnt let me because theres a comma in there.


I entered data before creating the relationships which is probably a poor move but whatever.


Basically my question is how do I get access to read the different required expertises (separated by commas) in the same field or whatever.

[pbaldy]

Each combination of consultant and expertise should be a separate record in that table. Then your relationship works.