I am using Access 2007. I am pretty new at this, and have this half-figured out. Can you help me figure out the rest of the way?
I am making a database to help keep track of assigned roles and staff. I want to be able to generate a report listing names, assigned roles, and contact info.
Here is how I have tried to do it:
Tables:
People, with fields AutoID (primary key), Name, Email
Staffing, with fields AutoID, Role1, Role2, Role3
I have set up a form to assign staffing. In the form, the user chooses an entry from a combobox (using [People].Name as its source, binding to the ID field.). This selection is stored in a field (Role1) in the Staffing fable.
Here is where the fun begins: The values in the Staffing table are, of course, numbers, since I bound the combobox to the ID column.
Using queries, I figured out how to get names & email out of the People table:
SELECT [People].AutoID, [People.Name], [People].email
FROM [People]
JOIN [Staffing] ON [Staffing].Role1 = [People].AutoID
Unfortunately, I've been stuck at this point. How do I get all my roles w/ names & email to show up on a report?
(I am also aware of to the fact that I may be setting these up entirely incorrectly.)
I am making a database to help keep track of assigned roles and staff. I want to be able to generate a report listing names, assigned roles, and contact info.
Here is how I have tried to do it:
Tables:
People, with fields AutoID (primary key), Name, Email
Staffing, with fields AutoID, Role1, Role2, Role3
I have set up a form to assign staffing. In the form, the user chooses an entry from a combobox (using [People].Name as its source, binding to the ID field.). This selection is stored in a field (Role1) in the Staffing fable.
Here is where the fun begins: The values in the Staffing table are, of course, numbers, since I bound the combobox to the ID column.
Using queries, I figured out how to get names & email out of the People table:
SELECT [People].AutoID, [People.Name], [People].email
FROM [People]
JOIN [Staffing] ON [Staffing].Role1 = [People].AutoID
Unfortunately, I've been stuck at this point. How do I get all my roles w/ names & email to show up on a report?
(I am also aware of to the fact that I may be setting these up entirely incorrectly.)