Primary Field with sub-records

[Sushil_Pawa]

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.

[Mohamed_Swella1]

Hi @Sushil_Pawa,

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

BR,
Mo

[kuovonne · Accepted solution]

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.