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.
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.