Help with formatting multi select grouping


#1

Hi! New user of Airtable.

I have a series of products. Some are bundled together. Some are in multiple bundles.

I set up a sample table to show what I mean.

So I have products A-I.

Product E is a bundle of products A, B, C, and D.

Product F is a bundle of products A and B.

G, H, and I are just plain stand alone products.

I want to be able to group by bundle so that product A shows up in both bundles when looking at a grouped view.

Here is the sample table that I set up to mimic my actual table: https://airtable.com/invite/l?inviteId=inv18NJ0A2OtypSrf&inviteToken=c2bf4b5b9e626cecdd9219298d1253c9d36af8744bc152a5568f976fced01184

Thanks so much!


#2

You need a junction table: https://support.airtable.com/hc/en-us/articles/218734758-A-beginner-s-guide-to-many-to-many-relationships