Skip to main content
Question

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

  • June 20, 2018
  • 0 replies
  • 48 views
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!
    This topic has been closed for replies.

    Hi Britney,
    No limit that I know of. I have a table with well over 200 lookup fields.
    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.
    Terms & ConditionsAccessibility statement