Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Primary Field with sub-records

Topic Labels: Base design
Solved
Jump to Solution
1521 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Can we have several sub-records for one primary field ? We make a quotation based on several quantity ranges. So all fields are the same and only the quantity and prices are different.

1 Solution

Accepted Solutions

If you are storing the exact same data in multiple rows, you should consider redesigning your base. See Structuring your Airtable bases effectively, particularly the section Identify redundancy that results in too few tables. A beginner’s guide to many-to-many relationships is also useful.

See Solution in Thread

2 Replies 2

Hi @Sushil_Pawa,

What you can do is use the Group option and group by the Primary field you are looking for.

BR,
Mo

If you are storing the exact same data in multiple rows, you should consider redesigning your base. See Structuring your Airtable bases effectively, particularly the section Identify redundancy that results in too few tables. A beginner’s guide to many-to-many relationships is also useful.