Question & Answer
Question
How can I display additional information from a child record based on a field's value.
Answer
In Maximo you can display information virtually through a relationship.
Sometimes there are situations you may want to display a value from a child table, for the user to see during the session they are viewing the record, but don't need it to be saved to the parent table.
For example you want to display an Asset's serial number in Work Order Tracking when the Asset field is populated.
In Database Configuration there is a Relationship tab.
Most relationships out of the box are the name of the child object.
For the WORKORDER object, on the Relationship tab, you will find an Asset relationship.
Using this relationship, you can add a textbox in App Designer and reference the RELATIONSHIPNAME.ATTRIBUTENAME in the attribute property to display that value when the key of the relationship is populated.
Launch Application Designer.
Select the WOTRACK application.
Select the Object Palette toolbar icon and drag and drop a textbox object onto the Work Order main tab next to the Asset field.
Highlight the new textbox and select the Control Properties icon.
In the attribute field of the properties enter ASSET.SERIALNUM
The ASSET in the attribute value above is the relationship name, not the object name.
Note: Users will be able to modify the original record's value through the relationship.
If this is not a desired functionality, set the inputmode in the properties to Readonly
Save the changes.
In Work Order Tracking, when an asset value is entered, the serialnum value will display in this new textbox virtually for the session.
Was this topic helpful?
Document Information
Modified date:
17 June 2018
UID
swg21508596