Access noob - need help Normalizing a database to 3NF, did I do it rite?

[John Big Booty]

I would have a table with the tech level in it as such

TBL_TechLvl(TechLvlID, TechLvl)
TBL_TechRate(TechRateID, TechLvlID, TechRate, EfectiveDate)

then in your tblClientServiceCalls, you would record TechID, TimeOnSite, DateOnSite. You can then simply check the date on site with the efective dates to determine the correct charging rate.

You could also do the same for the techs and their TechLvl, as presumably they would do training to improve their skill sets and therefore be eligible for higher billing rates.

TBL_TechLvlHist(TechID,TechLvlID, EfectiveDate)

 

[oZone]

Okay, thanks again.

By the way, Buckaroo Banzai is one of my favorite movies too