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/18101.aspxFri, 05 Jul 2013 15:21:25 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:18101Method_Jason0http://forums.method.me/cs/forums/thread/18101.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=18101<p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_65_start" style="overflow:hidden;"><span id="mce_66_start" style="overflow:hidden;"></span></span><span id="mce_1_start" style="overflow:hidden;">We received this email - <span id="mce_3_start" style="overflow:hidden;"><span id="mce_69_start" style="overflow:hidden;"></span></span></span></span></p> <p><span id="mce_0_start" style="overflow:hidden;"><span id="mce_1_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;"></span><span id="mce_67_start" style="overflow:hidden;"></span><em>&quot;I&nbsp;</em></span><em>am trying to put the Manufacturer part number on the quote. When I enter &quot;<span id="mce_61_start" style="overflow:hidden;"></span>EstimateLine.item<span id="mce_61_end" style="overflow:hidden;"></span>&quot; it gives me the entire grouping breakdown with the part number. How do I get ride of that and just see that part number?<span id="mce_2_start" style="overflow:hidden;">&quot;<span id="mce_4_start" style="overflow:hidden;"><span id="mce_47_start" style="overflow:hidden;"><span id="mce_67_end" style="overflow:hidden;"></span></span></span></span></em></span></p> <p>Jake,&nbsp;<span id="mce_70_start" style="overflow:hidden;"></span></p> <p><span id="mce_6_start" style="overflow:hidden;"><span id="mce_11_start" style="overflow:hidden;"></span>T</span>he<span id="mce_12_start" style="overflow:hidden;"></span><em> I<span id="mce_10_start" style="overflow:hidden;"></span>tem<span id="mce_12_end" style="overflow:hidden;"></span></em><span id="mce_10_end" style="overflow:hidden;"></span> dropdown field in the <span id="mce_14_start" style="overflow:hidden;"></span><em>EstimateLine<span id="mce_14_end" style="overflow:hidden;"></span></em> table <span id="mce_7_start" style="overflow:hidden;">contains</span>&nbsp;the <span id="mce_8_start" style="overflow:hidden;"></span><em>FullName<span id="mce_8_end" style="overflow:hidden;"></span></em> <span id="mce_18_start" style="overflow:hidden;">values</span>&nbsp;from&nbsp;the <span id="mce_16_start" style="overflow:hidden;"></span><em>Item<span id="mce_16_end" style="overflow:hidden;"></span></em> table. <span id="mce_5_start" style="overflow:hidden;">It sounds like you are looking <span id="mce_22_start" style="overflow:hidden;">for</span>&nbsp;the <span id="mce_20_start" style="overflow:hidden;"></span><em>Name<span id="mce_20_end" style="overflow:hidden;"></span></em> field from the <span id="mce_23_start" style="overflow:hidden;"></span><em>Item<span id="mce_23_end" style="overflow:hidden;"></span></em> table instead<span id="mce_25_start" style="overflow:hidden;"></span>. We can access&nbsp;<span id="mce_71_start" style="overflow:hidden;"></span>this field by adding the <span id="mce_27_start" style="overflow:hidden;"></span><em>Name<span id="mce_26_start" style="overflow:hidden;"><span id="mce_27_end" style="overflow:hidden;"></span></span></em> field<span id="mce_48_start" style="overflow:hidden;"> from the <span id="mce_51_start" style="overflow:hidden;"></span><em>I<span id="mce_49_start" style="overflow:hidden;"><span id="mce_50_start" style="overflow:hidden;"></span></span>tem<span id="mce_51_end" style="overflow:hidden;"></span></em> table</span> into the <span id="mce_29_start" style="overflow:hidden;"></span><em>EstimateLine<span id="mce_29_end" style="overflow:hidden;"></span></em> table as a linked field.&nbsp;<span id="mce_31_start" style="overflow:hidden;">To add this<span id="mce_53_start" style="overflow:hidden;"></span> linked field<span id="mce_32_start" style="overflow:hidden;"></span>, <span id="mce_53_end" style="overflow:hidden;"></span>go to <span id="mce_36_start" style="overflow:hidden;"></span><strong>Customize</strong><span id="mce_33_start" style="overflow:hidden;"><strong>&gt;Tables/Fields<span id="mce_36_end" style="overflow:hidden;"></span></strong> and click <span id="mce_38_start" style="overflow:hidden;"></span><em>Edit Fields...<span id="mce_38_end" style="overflow:hidden;"></span></em> for the <span id="mce_40_start" style="overflow:hidden;"></span><em>EstimateLine<span id="mce_40_end" style="overflow:hidden;"></span></em> table.&nbsp;<span id="mce_42_start" style="overflow:hidden;"><span id="mce_45_start" style="overflow:hidden;">Once you have added the<span id="mce_49_end" style="overflow:hidden;"><span id="mce_50_end" style="overflow:hidden;"></span></span> linked field<span id="mce_57_start" style="overflow:hidden;"> to the table</span>, you can edit your custom Estimate report in our Report Designer <span id="mce_58_start" style="overflow:hidden;"></span>and use your new field instead of&nbsp;<span id="mce_63_start" style="overflow:hidden;"></span>EstimateLine.It<span id="mce_73_start" style="overflow:hidden;"></span>em.<span id="mce_63_end" style="overflow:hidden;"></span>&nbsp;<span id="mce_64_start" style="overflow:hidden;"><span id="mce_72_start" style="overflow:hidden;"><span id="mce_74_start" style="overflow:hidden;"></span></span></span></span></span></span></span></span></p> <p>Please reply here on the forums if you have further questions.&nbsp;</p> <p>Jason<span id="mce_65_end" style="overflow:hidden;"><span id="mce_66_end" style="overflow:hidden;"><span id="mce_75_start" style="overflow:hidden;"></span></span></span></p>