title: Pull Attributes from Stock Item to SO Line custom field
body: <p>I'm relatively new to customization programming in Acumatica and I have a question about the best way to pull in attribute values from the stock item screen to a custom field on the SO Line in the sales order screen.</p>
  <p>I have done something similar on another screen using a FieldSelecting event and a PXSelect statement to pull data from another screen and update my custom field.</p>
  <p>Needing to pull the values from the attribute value is what's stumping me, should I just join to the CSAnswers table in the pxselect?</p>
  <p>I also wanted to ask if there is a better overall approach for pulling data from another screen into a custom field in an Acumatica customization.</p>
  <p>*update *
  I'm attempting to use the PXDBScalar attribute, but I cannot figure out how to join multiple tables.  Here's what I've tried.</p>
  <pre><code>    [PXDBScalar(typeof(
       Search2&lt;CSAnswers.value,
           InnerJoin&lt;InventoryItem,
               On&lt;SOLine.inventoryID, Equal&lt;InventoryItem.inventoryID&gt;&gt;&gt;,
           InnerJoin&lt;CSAnswers,
               On&lt;InventoryItem.noteID, Equal&lt;CSAnswers.refNoteID&gt;&gt;&gt;,
           Where&lt;CSAnswers.attributeID, Like&lt;QHOLDAttr&gt;&gt;
                             &gt;))]
  </code></pre>
  <p>Thanks
  Scott</p>