Finding Non-Null Columns

[scott50]

I am creating a database that will collect the dates when training was completed. I need to find all the the columns(training) a particular person has completed. I was considering trying to see if a column is null and then moving on to the next one. Any Ideas?

 

[GoDawgs]

First off you need to have different tables...one for the training classes, one for the students/workers/people, and finally one for just the personID and classID...if things are set up this way then you should have no trouble making a query to determine what classes each person has taken. Hope that helps.

Kevin

 

[scott50]

I currently thought I would set the db up like this

Employee Info(id,first,last,staff/hourly,department,job description

Then a tables for each department(20) with there required training. Also a general training table.

So each table would have columns with there training and a date of completion record.

I think Your suggestion will make it much easier and faster. I think I am still going to keep a table for each department. It should make it easier to find each departments requirements.