DEVELOPERS FORUM - How to create a link to Manufacturer data

Lee - Monday, March 23, 2009 11:38 AM:

Hi,

I'm new to Innovator and AML.  I have a list of Manufacturer Parts with Manufacturer as one of the attributes. I would like to link the listed manufacturer to the Manufacturer item to display the relevant contact information.

The following AML is my attempt at linking the manufacturer to its contact info.  

<AML>
   <Item type="Manufacturer Part"  action="edit"   where="[MANUFACTURER_PART].item_number='01234567' and [MANUFACTURER_PART].is_current='1'">
   <manufacturer keyed_name="ABC Co" type="Manufacturer">ABC Co</manufacturer>
   </Item>
</AML>

Any help is appreciated,

Thanks,

Lee

RobMcAveney - Monday, March 23, 2009 11:59 AM:

Hi Lee, and welcome.  Your AML is pretty close, but the value of the manufacturer property needs to either be the id of the Manufacturer item or a query to retrieve that id.  Try the following:

<AML>
 <Item type="Manufacturer Part" action="edit" where="[MANUFACTURER_PART].item_number='01234567' and [MANUFACTURER_PART].is_current='1'">
  <manufacturer keyed_name="ABC Co" type="Manufacturer">
   <Item type="Manufacturer" action="get">
    <name>ABC Co</name>
   </Item>
  </manufacturer>
 </Item>
</AML>

Hope that helps -

Rob

Lee - Monday, March 23, 2009 3:41 PM:

It worked. Thanks for your help

Lee