It is possible to lookup values based on the value entered in a field?
e.g. I am trying to deign a form for staff to submit overtime claims - I would like them to be able to enter their payroll number / staff code and the form to display their name and hourly rate in separate fields.
I have tried using the If Then Else statement but this is cumbersome. I would like to retrieve values from a lookup table as if using a vlookup statement in Excel.