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.