Dancing Fish
New Member
- Joined
- Nov 1, 2021
- Messages
- 6
- Office Version
- 365
- Platform
- Windows
I'm trying to translate matrix tables into a search in order to simplify what is on the tables. These are tracking what users are assigned to specific job codes, then what job codes are assigned to which training. The matrix tables are a couple hundred rows.
My first challenge is to get a list of what job codes a user might have and is laid out like below. A user can have multiple job codes and each applicable one is indicated with an "x".
Table 1: User's Job Codes
If I wanted to search by a specific user ex: User 1, how would I get a list of all job codes applicable to them?
Output desired:
My second challenge is then to search these returned job codes for their assigned training courses. Another matrix table contains this relationship in a similar format. I can invert the table if needed.
Table 2: Training Courses' Job Codes
Looking for the same type of output, just a list of all the training courses for the user.
Output desired:
My first challenge is to get a list of what job codes a user might have and is laid out like below. A user can have multiple job codes and each applicable one is indicated with an "x".
Table 1: User's Job Codes
Job Code 1 | Job Code 2 | Job Code 3 | Job Code 4 | |
User 1 | x | x | x | |
User 2 | x | |||
User 3 | x | x |
If I wanted to search by a specific user ex: User 1, how would I get a list of all job codes applicable to them?
Output desired:
User Name entered here | Returned Job Codes |
(User 1) | Job Code 1 |
Job Code 2 | |
Job Code 3 |
My second challenge is then to search these returned job codes for their assigned training courses. Another matrix table contains this relationship in a similar format. I can invert the table if needed.
Table 2: Training Courses' Job Codes
Job Code 1 | Job Code 2 | Job Code 3 | Job Code 4 | |
Training Course 1 | x | x | ||
Training Course 2 | x | |||
Training Course 3 | x | x |
Looking for the same type of output, just a list of all the training courses for the user.
Output desired:
User Name entered here (User 1) | Returned Job Codes | Returned Training Courses |
Job Code 1 | Training Course 1 | |
Job Code 2 | Training Course 3 | |
Job Code 3 |