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

Question

What is the maximum number of&nbsp;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.&nbsp;Thanks!

britneymenconi · Answer

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

gilbertspigelm2 · Answer

That's the annoying part.

gilbertspigelm2 · Answer

Hi Britney,No limit that I know of. I have a table with well over 200 lookup fields.

quickbasecoachd · Answer

There is no limit to the number of lookup fields.&nbsp; But from your description, I cannot understand why you need 60 lookup fields.&nbsp; It might be worth explaining the business purpose of what you are doing just to cross check that there is not a better approach.

britneymenconi · Answer

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.

Forum Discussion

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

Related Content

Field to "assign" a user group

Maximum Summary field not working

Formula - Rich Text field is not displaying zeros after the "."

All Fields not appearing in Pipelines "Select Fields to Specify Values"

Set "tab" order for form fields