Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Maximum Linked records?

Topic Labels: Base design
2845 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Raymond_Stamper
5 - Automation Enthusiast
5 - Automation Enthusiast

Does anyone know how if there is maximum limit on how many records from one table can be linked to a single record from another table. I know the maximum records that can exist in any one table (even on the enterprise plan) is 50,000. So, then, could I have a base with two tables where the first table has 49,000 records, all of which are linked to a single record in the second table? Thank you in advance for your help.

3 Replies 3

Hi @Raymond_Stamper and welcome to the community!

The max number of records is per base, and not per table. For the record, I was told by Airtable that the Enterprise plan can go up to 100k records.

Thanks. I actually spoke with their sales department about this recently. It is true that the Enterprise plan allows for 100,000 total records per base. However, even on that plan, any one table can only have a max of 50,000 records. So, for instance, on Enterprise you could have two tables, each w 50,000 records, whereas that is not possible with non-enterprise plans.

Aha, didn’t know that nuance. Thanks for sharing!