All right all. I am probably completely over thinking this, but at this point it is time to consult the experts. One thing to keep in mind is that I am very new to access.
I am in the process of creating a DB for my fire department. I am tracking our training among other things in the DB. However, I am focusing on the training for this thread. I have created a table for each firefighter for training as well as a table for the overall roster. I have created a listbox on a form that pulls first name, last name, rank, and training file name from the roster table.
Here is where I get lost. Once I select the firefighter from the listbox, I want it to pull the first name, last name, and rank from the Roster table an populate a form or report with this information. Then pull the data from the firefighter's training file and populate a subform or subreport under the previous information.
any assistance would be GREATLY appreciated.