need help creating database

[johnnyb]

So I need some help creating a database. I am creating a database to store memberships groups and when a user ask for access to a specific group there is only one person that can approve the access for that membership. So right now we use a list on paper to see which membership is approve by which person but I would like to have it all on computer. I was thinking of the design and made one table for the memberships and one table for the approvers but I am unable to figure out how that is going to work.

I want the user to either use a drop down list and select the membership or type it in by hand and execute a search and then the approvers of that memberships will be listed. I am not sure is that makes sense but what would be the correct way of doing this?

[Siiig]

You're certainly on the right track. I would probably make a single table, with the key field being the Memberships. That way you can run a query based on the specific membership (or even a Form that looks at this table) and it can output each member name.

Example:

Membership Approve1 Approve2 Approve3
Access Steve Randy
Forms Paul Steve James

Your form would look at the Membership "Access" and pull up the information that goes along with it.