Is it possible to display the serialnum of a parent item in inventory
You can create a relationship on the INVENTORY object to the ITEMSTRUCT object to use as a reference in Application Designer to display your data from the parent in Itemstruct in the Inventory application.
To create a relationship, launch Database Configuration:
Select the INVENTORY object
Select the Relationships tab
Select New Row
Give the relationship a name (remember this name) for this example we'll call it ITEMSTRUCTINV
Child Object: Itemstruct
Where Clause: (parent=:itemnum or parent is not null) and
itemsetid=:itemsetid and itemnum=:itemnum and itemid!=:itemnum
Launch Application Designer and select Inventory application.
Select the Object Palette toolbar icon and drag and drop a textbox object where you want this new field.
Highlight the new textbox and select the Object Properties toolbar icon or right click on it and select properties.
In the Attribute property enter ITEMSTRUCTINV.SERIALNUM
The syntax is relationshipname.attributename where the relationship is the name from the previous step and the attribute name is the field from the child object.
In the Inputmode property field put the value READONLY so that user cannot change the original record's serialnum value through the relationship.
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.