Maximo Forum

I am having an issue with a lookup returning the projectid instead of projectnbr. The lookup is displaying fine (shows projectnbr, name, and status of all active projects) but I get an error message when it validates saying “BMXAA4191E – Project Number X is not valid.” where X is the projectid of the one I selected instead of the projectnbr. I would like to have the lookup menu return projectnbr for the selected entry, but it seems to always return projectid (the auto-created column when the PROJECT object was created). I have tried editing the lookup map, but it still returns projectid. Any and all help is greatly appreciated! 

Thanks!

Below I have listed all the steps I have taken to set this up:

– I have created a new table called PROJECT (fields include: projectnbr, status, and projectid (auto-created by maximo) plus a few other non-relevant fields)

– I have created a new power application called Projects 

– I have added a few sample projects 

– I have created a Table domain called PROJECT based on the PROJECT object with a validation where clause of projectnbr=:projectnbr and a list where clause of status='ACTIVE'

– I have added a field on the Workorder table called projectnbr and set Same As Object: PROJECT, Same As Attribute: PROJECTNBR, and Domain: PROJECT

– I have edited the Lookup Map for projectnbr with Target Attribute: PROJECTNBR, Source Object: PROJECT, and Source Key: PROJECTNBR (I have also tried PROJECTID in Source Key, neither worked), Sequence: 1, Allow Null: Checked

– I have added an entry to the LOOKUPS.XML file called PROJECTS with 3 fields showing: PROJECTNBR, NAME, STATUS

– I went into Application Designer and added a textbox for the projectnbr field to the Workorder tab of WOTRACK. I specified Attribute:PROJECTNBR, Lookup:PROJECTS, and Go To Application: PROJECTS