http://forums.method.me/cs/forums/13.aspxAsk technical support questions, how do I? Questions... Or anything else you want to know from the Method Team and other Method users.enCommunityServer 2007.1 SP2 (Build: 31113.47)http://forums.method.me/cs/forums/thread/21910.aspxTue, 20 May 2014 16:46:28 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:21910robert.cowart0http://forums.method.me/cs/forums/thread/21910.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=21910<p><span id="mce_0_start" style="overflow:hidden;">Russell,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span>Thanks for the reply. &nbsp;We are using the Standard version so we cannot alter <span id="mce_3_start" style="overflow:hidden;"></span>tables. &nbsp;Looks like we cannot accomplish our dropdown goal.<span id="mce_1_start" style="overflow:hidden;"></span></p> <p>Thanks.</p>http://forums.method.me/cs/forums/thread/21873.aspxWed, 14 May 2014 20:43:04 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:21873Method_Russell0http://forums.method.me/cs/forums/thread/21873.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=21873<p>Hi Robert,</p> <p><span style="overflow:hidden;"></span></p> <p><span id="mce_6_start" style="overflow:hidden;">You could add the Other1 field to the grid, but since this field is a text type, it would not be a dropdown. If you wanted to use a dropdown, then you would have to add a new <span id="mce_7_start" style="overflow:hidden;">dropdown&nbsp;</span>field to the SalesOrderLine table<span id="mce_8_start" style="overflow:hidden;">.</span></span><span id="mce_5_start" style="overflow:hidden;"></span></p> <p><span id="mce_9_start" style="overflow:hidden;">Next</span>, you would make a copy of the sales order screen (QuickBooks_SalesOrder) so that you can edit it, if you haven&#39;t done so already.<span id="mce_3_start" style="overflow:hidden;"></span></p> <p><span style="overflow:hidden;"></span></p> <p>Then, click the edit button on the SalesOrderLine grid. Skip to step 2 on the wizard to add the new column to the grid. Select the Other1 field<span id="mce_10_start" style="overflow:hidden;"> (or new dropdown field)</span>, set its properties and click Insert Column. Once you save &amp; publish the screen, you will be able to see the field on the grid.</p> <p><span style="overflow:hidden;"></span></p> <p>For more information, please see http://www.methodintegration.com/method/kb.aspx?folder=methodcrm&amp;article=Grid&amp;id=94.</p> <p><span id="mce_0_start" style="overflow:hidden;"></span><span id="mce_2_start" style="overflow:hidden;"><span id="mce_11_start" style="overflow:hidden;"></span><span id="mce_12_start" style="overflow:hidden;">If you have any further questions please let me know.</span></span></p> <p>-Russell</p>http://forums.method.me/cs/forums/thread/21853.aspxTue, 13 May 2014 20:46:13 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:21853robert.cowart0http://forums.method.me/cs/forums/thread/21853.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=21853<p><span id="mce_0_start" style="overflow:hidden;">How can I create a dropdown for SalesOrderLine.Other1 and put it into the grid in a SalesOrder screen? &nbsp;Thanks!</span></p>