The Rev
Registered User.
- Local time
- Yesterday, 22:45
- Joined
- Jan 15, 2003
- Messages
- 118
I need a query that is based on 2 separate tables. I have a Requirements table and an Assignments table. We assign different groups of requirements to 5 different groups of auditors (1_3_5, 2_9_10_11_12, 4_7_8, 6_13_14, and On-Site). My Assignments table has 5 separate fields in them to assign a separate auditor to each of the fields. I need to figure out how to create a query that will list all of the requirements sequentially and who is assigned to that specific requirement.
Requirement Table:
Req_Sorting
Requirement_Number
Requirement_Description
Assignments Table:
ID(AutoNumber)
1_3_5_FL
2_9_10_11_12_FL
4_7_8_FL
6_13_14_FL
On_Site_FL
As stated, I assign individual names to each of the Functional Lead (FL) table using a combobox linked to a separate Staff table. I need a query that lists the Requirement Number and who is assigned to it. No clue where to start. There's nothing in common between the two. Thanks in advance!
Requirement Table:
Req_Sorting
Requirement_Number
Requirement_Description
Assignments Table:
ID(AutoNumber)
1_3_5_FL
2_9_10_11_12_FL
4_7_8_FL
6_13_14_FL
On_Site_FL
As stated, I assign individual names to each of the Functional Lead (FL) table using a combobox linked to a separate Staff table. I need a query that lists the Requirement Number and who is assigned to it. No clue where to start. There's nothing in common between the two. Thanks in advance!