I have a question to which I am not sure how simple or complicated the solution will be.
I have a table that contains several fields. Two of these fields are "SalesFrom" and "SalesTo" with several other fields.
I have another table that contains a fields called "Sales". I need to see what record the current sales value corresponds to (i.e. Sales $1541.15 is between 1401 and 1600. So I need to go to this record and return the value in the field "TotalHours_c").
I just can't get my head around how to check to which record should be looked up depending on the value in Sales.
I hope my question makes sense.