Hello! I'll start by saying I'm very new to access and have not done any VB
In Access 2007 I'm building a form to show data for a "Technician" (Each technician is 1 record).
In my data a technician has multiple Skills assigned to their TechID; I used 3 tables so it looks like: tblTechnician contains TechID > tblTechSkill links SkillID to the TechID > tblSkill links the name of the skill to the SkillID.
I want to make a list on the form that shows the Technician's skills, it doesn't have to do anything, just display the data; but I've only managed to display every skill name available instead of the data relating to that technician.
My question is what is the best way to display this? (Listbox, Textbox etc) And how do I only show skills for the record that's currently displaying?
Thanks to anyone who would try to help me out and if I didn't explain something well, please let me know