Employee list
Hello, I have a multi-select text field with employee name choices that is going to be archived and no longer used. In that fields place I will be adding fields that relate back to a connected em...
Forum Discussion
Hi there,
Yes, you can do this. There are a couple ways. If the names are the Key Field on your Employee Roster table then you have only to make that field the Reference Field in the relationship to the Roster table.
If the [Employee Name] is not the key field for your Roster Table then you will need to do an import based on another unique field, called the Merge Field. Something like an [Employee Number] would do the trick.
Your 3rd option is to organize the data in Excel 1st and do what is called a VLOOKUP. It's my experience that no one enjoys this option so I'd definitely recommend one of the above options before this one. Excel FAQ on VLOOKUPs.