Search results

This is what I have done, with some success only: I created an Union query that normalizes that should normalize the data, taking the CompanyID field and assigning to it each NAICS code for a certain company SELECT CompanyID, NAICS1 from 06CompanyDirectorywNaics where NAICS1<> " UNION Select...

This is it, where is the mistake? CompanyTbl CompanyID(PK) - one to many w. CompanyID in CompanyNAICStbl CompName Street City NAICS1 NAICS1 NAICS3 NAICS4 NAICS5 NAICS6 NAICSTbl Title NAICS(PK) - one to many w. NAICS in CompanyNAICStbl CompanyNAICSTbl CompanyID (CompositePK) NAICS...

Thanks, SJ, That's what I did. For some reason though, the linked fields come up empty in all tables of the relationship. I must be doing something wrong, but cannot see what, this is pretty basic. Noch keine Taten!

SJ, The three tables part I got, what I cannot solve is how to link the up to 6 Products/NAICScodes for each company into the relationships. Von mir, noch keine Taten!

Sergeant, Does not work. Here's what I did: CompanyTbl: CompanyID (PK)this PK linked in One-to-Many with the CompanyID (CPK) in the intermediate table Name Street etc. NAICS1) NAICS2 NAICS...6 intemediate table is CompanyNAICStbl CompanyID(CPK) NAICScode(CPK) this linked in Many-to-One...

Thanks, Sergeant, Do I leave the NAICS1, 2 fields etc in the CompanyTbl? What is CompanyProductID exacly in the CompProductTbl? Sorry for being a pain, but been stuck on this for a good few days...

Ok, here it goes: Got these tables: CompanyTbl: CompanyID (PK) Name Street etc. NAICS1(this is a standard industrial code, a 6 digit number telling about their product/service) NAICS2 NAICS...6 (company can have 1-6 NAICS codes) A layman has no clue what these NAICS code are, so each and...