Hello. Im a beginner but Ive probably watched about 50 videos and have created a few access databases but I havent seen any videos so far that would help me assign a value to a field by a multiple of .5 hours.

For example, I want to be able to assign man hours to a difficulty level (lets call it DifficultyID). So, a DifficultyID value of 1 should equal .5 in the ManHoursID and 2 should equal 1hr and so on, and so on.

So far I created a DifficultyT table with a DifficultyID from 1 to 5 and a ManHoursT table with a ManHoursTotalID from 30 to 150 (since Richard says dont use increments of hours). I also created a DifficultyID in the ManHoursT table as the foreign key. After that, its all hazy for me.

I want the end result to be that Whenever I assign a DifficultyID in a combo box for that activity, I want the difficulty level to reflect that .5 respective  multiple. In other words, if 5 is chosen in the difficultyID, I want the man hours to equal 2.5 hours. And eventually, a want to sum several difficultID values (jobs) in a total sum (total man hours).

I hope I explained this right but thats what Im hoping for some guidance on. Thanks!