I have a project that I haven't stated yet and I'm looking for advice on some best practices.
essentially I will have a table with personnel information, standard stuff First Name, Last name, ID number, ect.
Then I will have a table with some on the job training information such as Academic hours, practical hours, Date of OJT, approximately 30 OJT task which I plan to capture how many times each task is completed per date, Some Comments, and an overall performance grade for the OJT day.
My question is should I break a table like this up in to smaller tables? If so whats the best way to link on that data back to say the "ID number" so I could filter all events by ID number and date for reports?
essentially I will have a table with personnel information, standard stuff First Name, Last name, ID number, ect.
Then I will have a table with some on the job training information such as Academic hours, practical hours, Date of OJT, approximately 30 OJT task which I plan to capture how many times each task is completed per date, Some Comments, and an overall performance grade for the OJT day.
My question is should I break a table like this up in to smaller tables? If so whats the best way to link on that data back to say the "ID number" so I could filter all events by ID number and date for reports?