
Hi All,
I am quite new to D365 BC. I have a requirement to create a custom table in which a field called Project Manager which should be a lookup when one can select a Employee Id from the Employee Table and the Employee Name is Displayed in the same Project Manager field.
Can someone pls give a detail explaination how i can achieve this?
Thanks in advance
easiest way is to create 2 fields
1. Project Manager Code
2. Project Manager Name
use tablerelation for PM Code field to Employee table and write code in onvalidate trigger to get name from employee and fill in PM Name field or create PM Name field as flowfield