Get the employee name while assigning fixed assets

poppinspoppins Member Posts: 647
Hi everyone,

I have an issue with assigning fixed assets to employees...
The field Responsible Employee displays the Employee's No....but my customer wants the First Name and the last Name displayed, not the No.
How can I do that???


  • Options
    mohana_cse06mohana_cse06 Member Posts: 5,503
    Or you can create new flow field as Responsible employee name and show it under responsilbe employee field which shows name
    Lookup(Employee."First Name" WHERE (No.=FIELD(Responsible Employee)))
  • Options
    ppavukppavuk Member Posts: 334
    or something like this in onaftergetrecord, if you want full name:
    if empl.get("Resp. Enpl. No.") then
      fullname := empl."First Name" + ' ' + "empl.last Name"
      fullname := '';

    set fullname a source for your new control on form.
  • Options
    poppinspoppins Member Posts: 647
    Thanks a lot guys :mrgreen:
Sign In or Register to comment.