I'm working on an application which tracks and stores employee certifications and education levels.
As it stands, I have one SP list for the general employee info (Hire date, years of professional experience, etc), one for education (Degree, School, Year) and one for certifications (Cert, year).
What I'm trying to figure out is how to create relationships between these data sets. So, for example, I can enter a record in the employee list then link it to multiple education entries or certification entries. For that same employee.
For example, employee A could have three different degrees, and id want those education list entries to be linked to their main employee list entry.
Is this possible? If so, how?
Thanks in advance!