Hi, trying to join workorder table to ticket table but at a lost as to which fields to join. any help?
Posted 19 April 2016 - 12:29 PM
Did you try TICKET.ORIGRECORDID (where TICKET.ORIGRECORDCLASS = 'WORKORDER') = WORKORDER.WONUM?
Posted 04 May 2016 - 05:34 AM
Select * from Maxrelationship where parent='WORKORDER'. This table has all the maximo table relationship