Help mult. tables 2 Qry > > not editable

[Cameroncha]

This seems to come up a lot and i am really frustrated.

I have a fairly large table with a primary key of SKU
certain SKU values share multiple producers, categories, ect.
I have a table set up Many2Many to deal with these.

They are attached via the SKU and the PRODUCERID, ect.
I would like to take data like PRODUCERID and integrate into a single query for editing

Here lies the problem: Every time i integrate more than 1 table into a query Access either turns off the "add new item icon" or doesn't show the data at all.

I dont understand this.
I have attached a pic of my relationships and the query in question.
What am i doing wrong.

 

[Cameroncha]

Thanks for your input.

The reasoning for my structure is that one SKU can have multiple producers. Thinking about this more, i reallly dont (think that i) need multiple row values for each producer

SKU(s) have ProducerID1, ProducerID2, Producer3.... but not that often. Is it possible, (or a good idea) to "point" ProducerID1 and ProducerID2 at the same set of data values (my Producer table) instead of making 2 seperate rows of information keeping it as one.

I would rather have them listed together in a single row Producer1, Producer2, Producer3 < but pull values from 1 common table.

I am coming from and am used to using Excel but have grown out of it, i am having a hard time understanding "how this could all come together" in a cohesive manor for updating / sorting the information.

Does this Relationship stucture seem appropriate for my needs. If not, what books, resources, techniques would you recommend. I've purchase several books already: "Running Microsoft Access -- Microsoft", and another aimed at spotting and fixing errors (and will probably buy a few more.) Please, if you could point me in the right direction if you know of one.

Thank you for your time.