Well, shoot.

You're right -- it didn't come out exactly like it should have. I did import the Customer Diagnosis table from another database, but in the final query, each resource comes up in each category. It's a start, as far as getting things to show up, but not exactly what I hoped for. Anyway it will buy me some time!

I think having a master table is a good idea - I didn't set up the database to begin with, or I probably would have done it that way. The person who started it was an intern and doesn't work here anymore so I'm taking up where she left off and I'm not entirely sure what she did. Each table has different field names.

Now... there is one table that won't let me into design mode. It says either I have something open, or I don't have permission, even when I close everything and open it again.