Aug 05, 2021 04:22 AM
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.
Aug 05, 2021 07:17 AM
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.
Aug 05, 2021 10:35 AM
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.
Aug 05, 2021 10:46 AM
Aha, didn’t know that nuance. Thanks for sharing!