Courses Table to old database
I have an old Employee Database that I would like to add training to. I am still alittle confused as to the proper way to set it up and connect relationship. I would like to put a portal on the Employee layout and when I select the course number, it populates course name but leaves date blank so I can add (does this sound right). I have made a courses table but do I need a courses attended and if so what fields go where and making the connections is where I get lost. Thanks if anyone can help.