Creating a subform to manage team members

[thesolution]

This is my first post on this forum, thank you for giving me the opportunity to share the problem I am experiencing in Access 2007. I hope to learn a lot from this forum! I will do my best to express the issue I am facing.

So I am attempting to develop a database to keep track of groups within our organization. The database will contain generic information about the group, what is it's purpose, goal, etc. Each group has specific personnel attached to it; requestor, team leader, sponsor, and so on. I made separate tables for each of these specific members instead of making one single personnel table. The reason I did this was because I was having difficulty relating the tables. It would be nice however to have everyone on just one table.

In a form, I have all the data fields covered, using drop-down boxes for the specific members. However, the issue I am faced is with the general team members of each group. There can be X amount of general members for each group, thus it would not seem feasible to make a text box for each. I was hoping to use a subform and having the ability to list all the members (not the specific ones) within it. I'm not sure how to relate the tables though. How can I make sure that each record will only show members that are assigned to that group within the subform?

I have attached a copy of my database for reference, many thanks in advance!

 

[vapid2323]

If possible save the file in a Access 2003 format, you will get more help

 

[thesolution]

Good idea, thanks for that.

I went ahead and made a few changes to the database. Most notably, all personnel are on one table. However once again I am having issues with the subform, I cannot edit names or even show the member's name in it.