I just can't wrap my brain around it today.
We run a staffing agency with workers that have to be certified every year in many different things. I mostly use a form that is based on many tables to be able to track all of these dates and run reports from them.
We are starting a new branch of the business supplying our own training and I want to be able to link the new training to the form I already have in place, and the workers that I already have in my system. The tables related to this topic are as follows:
Tax Info:
ID (related to employee)
Application: (yes/no)
SS Number
other fields
Training:
ID (related to employee)
Passport (date certified)
Scaffolding (date certified)
2 Hr Lead (date certified)
other fields
Classes Available:
2 Hr Lead
Passport
Scaffolding
Fall Protection
What I would LOVE to do is: have a table or form that I can enter the SS Number, and the name to be generated if it already exists in the system or I can type it in if the name does not already exist.
I would also like to have a pick list of the classes (which is why I set up "Classes Available"), but when I pick the class, I want the date certified to enter into my already existing form of basic employee information.
Thank you so much for reading this, please dumb down your response as much as possible, I can't do big words...