I will do my best here to do what you are asking- I am still a little unsure exactly what you mean by structure, but here goes. If there is another way to do this I'm all ears!
The resource table uses an autonumber, and contains the ResourceDescription field, Rate field, etc. I have three tables that contain the hazards, response activities, and resource categories, they all contain only two fields, an autonumber and the name of the hazard, etc. The junction table actually uses the autonumbers from these tables (FK's) as the composite PK. ( The query form returns the written word. ) Part of my problem may be in the table structure- I can't figure out how to link the same resource record to than one category. So right now my junction table and resource table have no relationships between them, obviously a problem. I would like the ResourceCategory field to be the link. The hazards, response activities, and resource categories all have only unique entries, but there will be several records for each ResourceDescription.
I like the idea of cascading combo boxes- where would I look for more info about them? And I have a little experience with subforms, and was trying that approach, but it got too confusing.
I got the idea for the junction table here at UA, I would never have thought of it on my own, and I'm certainly not attached to it, but I don't know another way to establish all the many-to-many relationships. I keep getting close to what I want but there's always that missing crucial link. Thanks for the help, and I hope this is what you meant.