If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Query to find select columns in several tables....Help!
Here's the situation: I have 22 personnel. Each is in a different category
(Enlisted Air Force, Enlisted Army, Officer Air Force, Officer Army) Each category has different training requirements. Please note that in my Personnel Table, each person is actually assigned to one of those categories. (Hoping that it might be in some way helpful to finding a solution) What I've done: I created 5 Tables. Table 1: Personnel Data. The key field is Social Security Number. It does include a dropdown selection of the 4 categories mentioned above. Tables 2, 3, 4, and 5: Each one is a different category of training. I entered the field headings as the course titles, with Yes/No to track training completion. I did use an ID index, but all tables are linked via SSN to the Personnel Data table. I 'assumed' that when I maximize the little '+' sign in the Personnel Data table, it would show me the record in either of the 4 training tables that had that person's SSN in it, and only the record from the specific table. I was wrong. It is requiring that I only pick one table to link to the entire personnel table. The problem with this is that then I lose the other 3 completely different training requirements tables! There is not SO MUCH training (maybe 20-25 courses in total) that I cannot consolidate into one table. The problem is that I need to know what is required in addition to what is completed. (maybe to a 'training course 1 required, training course 1 complete?) I thought by doing it this way, the SSN in the table would require that training for that individual, and the yes/no within the table would indicate if it were complete or not. How do I get my data back out?!?!?! I'm hoping for something like this: SSN1, Last Name1, First Name1, List of required courses and completions SSN2, Last Name2, First Name2, List of required courses and completions I though a query might work, but I'm only getting results with ALL of the data or only the ones completed by the individual (yes checked) |
Thread Tools | |
Display Modes | |
|
|