Count records in another table

[Alex_Ma]

Hello, Looking for a method to count records in another table. In this case, I have a table with part numbers and their associated product. In another table, I want to count for each product, how many parts are in it by counting the part numbers from the first table. TYIA

[Vivid-Squid]

Hi @Alex_Ma,
You have the parts linked to the products? In the products table add a Count field to count the linked parts.

[Alex_Ma]

@Vivid-Squid Parts and Products are in 1 table. and I’d like to do the count in another table.The first image is what’s in table 1. The second is what I want to show in the 2nd table where I’m trying to figure out the formula for the # Parts column. Thanks

[Vivid-Squid · Accepted solution]

Airtable being a database first, works a little differently than a spreadsheet. Since Parts and Products are separate concepts with unique metadata, they should be in separate tables. Then you link those records and you can use the native airtable features to count.