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/31516.aspxFri, 12 Feb 2016 18:04:44 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:31516Sixtel0http://forums.method.me/cs/forums/thread/31516.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=31516<p><span style="overflow:hidden;" id="mce_0_start">Excellent! thank you! </span></p>http://forums.method.me/cs/forums/thread/31515.aspxFri, 12 Feb 2016 17:59:50 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:31515Method_Inderdeep0http://forums.method.me/cs/forums/thread/31515.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=31515<p><span id="mce_0_start" style="overflow:hidden;">Hello Sixtel,</span></p> <p><span id="mce_0_start" style="overflow:hidden;"></span><span>The entity table is a special table :) It encompasses the Customer, Vender, Employee and Other name tables into one. So you can think of it as the Customer being a &lsquo;subset&rsquo; of the Entity table for instance. The reason this is done is so that you can for example be able to write a check to an employee, to a vendor or even to your customer in the case of a refund.&nbsp; If the entity table didn&#39;t exist then you wouldn&#39;t be able to do that and my many other cross-table functionality that is possible. It is done this way behind the scene in QuickBooks as well. The entity table cannot be modified, instead modification can be done to the &#39;subset&#39; tables.</span></p> <p><span></span><span>Contact is&nbsp;</span><span id="mce_1_start">not a subset of Entity. &nbsp;The Contacts table is a Method only table. &nbsp;It has linked fields from the Entity table, but they are separate fields. &nbsp;The Contacts<span id="mce_2_start">&nbsp;table hold all of your contacts and does not sync to QuickBooks.</span></span></p> <p><span id="mce_1_start"><span id="mce_2_start"></span></span><span>Think of using the Entity table for data retrieval. So if you have a dropdown and for instance you wanted to filter vendor and employee then you can use the Entity table and show all your vendors and Employees, otherwise you wouldn&#39;t be able to see both types in one dropdown. For data entry it is best if you use the specific or &#39;subset&#39; tables.</span><span id="mce_1_start" style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;"></span></span></span></p> <p><span id="mce_1_start" style="overflow:hidden;"><span id="mce_2_start" style="overflow:hidden;"><span id="mce_3_start" style="overflow:hidden;"></span></span></span><span>&nbsp;It is not recommended that you create a screen based off entity table. It would be best if you did that via the subset tables.</span></p> <p>-Inder</p>http://forums.method.me/cs/forums/thread/31512.aspxFri, 12 Feb 2016 16:54:50 GMT3393c1ec-311b-4812-96cb-ad8c611bba4f:31512Sixtel0http://forums.method.me/cs/forums/thread/31512.aspxhttp://forums.method.me/cs/forums/commentrss.aspx?SectionID=13&PostID=31512<p><span style="overflow:hidden;" id="mce_0_start">Hi all! </span></p> <p></p> <p>So, I have just found out that there is an Entity table that seems to hold everything that is in the Customer table and the Contact table?</p> <p></p> <p>Im having trouble understandthing the function of this table, specifically I am having throuble understanding which table i need to be working in when. I have added a bunch of stuff to my Customer table, but should I really have added all that to the entity table? Should i build my grid views on the entity table, or the customer table?</p> <p></p> <p>thanks! </p>