I have a database that basically consists of company names and codes on what jobs that company can do for my employer.

Company codes
TravisCo 20041, 20084, 20032
TimCo 20084, 30052, 30078



etc..
I have one database that has every code, and the description of the code.
I have one database that has the client info and a "Code" field that I have set up to lookup the code from the first database, allowing multiple values.

when I try to append the company database with an temp table that has company name and their applicable codes I get "in INSERT INTO query that contains a multivalued field cannot contain another field"
If I only have the "code" listed on the query then it tries to run on every company.

What am I doing stupidly?