Method Community

 

Entity Table

Last post 03-27-2009 5:34 PM by jallen. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 03-27-2009 4:40 PM

    • jallen
    • Top 100 Contributor
    • Joined on 03-10-2009
    • Atlanta, GA
    • Posts 49

    Entity Table

    Why?

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

    Table does not allow adding fields.

     

  • 03-27-2009 5:00 PM In reply to

    Re: Entity Table

    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! Smile

  • 03-27-2009 5:19 PM In reply to

    • jallen
    • Top 100 Contributor
    • Joined on 03-10-2009
    • Atlanta, GA
    • Posts 49

    Re: Entity Table

    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?

  • 03-27-2009 5:34 PM In reply to

    • jallen
    • Top 100 Contributor
    • Joined on 03-10-2009
    • Atlanta, GA
    • Posts 49

    Re: Entity Table

    Got it...

    Sometimes it takes me a while to connect the dots!

Page 1 of 1 (4 items)