Regardless of whether you set up a looked up value setting on a Rate field in the Hours table, an auto-entered calculation that multiplies the Rate times the total hours or an unstored calculation that multiplies the Rate times the hours, you first need a valid relationship between the two tables:
Hours::RateLetter = Rates::RateLetter
With that relationship, you can set a rate field in Hours with a looked up value setting that will copy over the Rate from the Rates table each time you select or change the value of the Hours::RateLetter field.
I have a relationship of Rates::RatesDesription to Users::RatesDescription and then
Users::RatesDesription to Hours::RatesDescription and then
Does that work? I cannot make a direct link without causing a duplication of the Hours table as it becomes circular, I think I need the realtionship between the User table and the Hours table for other reasons.
I attempted to take the relationship aspect out of it just in order to get the calculation right by attempting to get the value for field on the same table. In other words on the Rates table adding a field that displays only the A rate, which cannot seem to do. I felt if I could do that without a relationship involved, then I could look to do it across tables.
Does that make sense?