Discussions

Expand all | Collapse all

Maximum Number of ""Field Lookup""s Limit?

  • 1.  Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:09
    What is the maximum number of New Lookup Fields I can add to a Table?

    I have over sixty types of jobs I would like to track; therefore, I would like to add over sixty Lookup Fields to my Activities Table from my Projects Table. I wanted to make sure I can add that many before I put in all the effort since I can only add three at a time. 

    Thanks!


  • 2.  RE: Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:13
    Hi Britney,
    No limit that I know of. I have a table with well over 200 lookup fields.


  • 3.  RE: Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:15
    Excellent! Muahahaha!

    I sincerely thank you for your quick response. Now if only I could add more than three at a time...


  • 4.  RE: Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:16
    That's the annoying part.


  • 5.  RE: Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:14
    There is no limit to the number of lookup fields.  But from your description, I cannot understand why you need 60 lookup fields.  It might be worth explaining the business purpose of what you are doing just to cross check that there is not a better approach.


  • 6.  RE: Maximum Number of ""Field Lookup""s Limit?

    Posted 06-20-2018 19:23
    There are this many types of inspections that we track, each having its own process flow and requirements. Each project can have anywhere from one to about thirty different types of required inspections. So there will be some Form Rules sprinkled in as well so users don't have to see all 60 types on every project.