Method:Classic General Q&A

Re: Entity Table

jallen — Fri, 27 Mar 2009 22:34:57 GMT

Got it...

Sometimes it takes me a while to connect the dots!

Re: Entity Table

jallen — Fri, 27 Mar 2009 22:19:52 GMT

Yes... I understand and it worked. However, what I was trying to do is use the customer (recordID) as a "job number" because it's unique and auto generating number.

Would it be better if I created a new field in customer table and make that auto generate? if so, how?

Re: Entity Table

Anonymous — Fri, 27 Mar 2009 22:00:18 GMT

The Entity table is a 'special' table that exists in Method only - it doesn't exist in QuickBooks and you cannot add fields directly to it. You can add fields to either the Customer, Employee or Vendor table and miraculously the field will automatically show up in the Entity table for you! :)

This is similar to the Item table. New fields have to be entered on another table: ie ItemInventory, ItemGroup, etc. for them to appear in the Item table.

Hope this helps!

Entity Table

jallen — Fri, 27 Mar 2009 21:40:46 GMT

Why?

When tring to ad a field in the Entity Table I receive the following:

Table does not allow adding fields.