Lookup field for corresponding value?
Hello - This is novice question so please bear with me. I'm looking to replicate
vlookup function in Excel. I've read several related posts on the forum, but still do not understand.
Example:
* Two forms - Department and Employees. The Employee form contains fields such as Employee Name, Phone Number, Email, etc.
* Department form contains lookup field that enables user to select Employee Name (employee_name) from Employee form.
* I would like to include another field in Department form which would automatically display the phone number (phone_number) associated with the Employee Name that is selected by the user.
* In Excel, this would normally be accomplished through the vlookup function.
Any help is much appreciated!