Help

Primary Field with sub-records

Topic Labels: Base design
Solved
Jump to Solution
3296 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Sushil_Pawa
4 - Data Explorer
4 - Data Explorer

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
kuovonne
18 - Pluto
18 - Pluto

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

kuovonne
18 - Pluto
18 - Pluto

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.