I’m adding a section in the form AMCaseParameters and want it to be a lookup of employees. I found a post by Martin that says to create a relation of my field to HCMWorker.PersonnelNumber. This works almost perfectly. It shows the personnel number and when I click the drop down I see a list of PersonnelNumbers with names. Users will like this to search, but when they choose someone, I want it to show the name, and not the peronnelnumber. I also think ideally it would store the Person in the table.
Here’s a quick summary:
I added a field called TCI_RMACustomerContact in the AMCaseParamaters table
I added a field group called TCI_RMACustomer and added that field to that group
I added a relation in the relations of that table from TCI_RMACustomerContact to HCMWorker.PersonnelNumber
I added a tab page in the form AMCaseParameters and then added a group called RMACustomerService
I changed the datasource of that group to AMCaseParameters and datagroup to TCI_RMACustomer
Can someone help me figure out how to change it shows the name instead of personnelnumber?
