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.
Solved
Primary Field with sub-records
Best answer by kuovonne
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.
+17Hi @Sushil_Pawa,
What you can do is use the Group option and group by the Primary field you are looking for.
BR,
Mo
+27If 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.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.