I have an SP list with Employee as Choice Column and a number column. I thne have a main list that charges out per hours depending on the person assigned. So I f I put BOB down, I want a column that can then lookup BOB and Apply £50 rate an hour. I can then setup a calculated column to times these values.
Any idea how to ahcieve this?
