Skip to main content

Listing out sub category

  • November 3, 2022
  • 1 reply
  • 8 views
E
Forum|alt.badge.img+4

Hello,

Ok, the set up, It’s a database.

The Variables :

  • First Column = Item ID

  • Second column = Media ID

  • Third Column = Vender ID

I have multiple Item ID’s that share the same Media ID. I would like make an interface view where the Media IDs are listed out (but not repeated), and filtered by the Vendor IDs. So far, I cannot seem to find a way to do this without all of the Item IDs that have the same Media ID listing out as well.

I hope this makes sense to someone.

Thank you.

    1 reply

    TheTimeSavingCo
    Forum|alt.badge.img+31

    Hmm, if it’s purely visual, you could group by the media ID column and collapse them all?

    If you actually need to interact with it, you’re probably going to need to create a new table for it, and you can try that by converting your media ID column into a Link to another table column. You’d then pull the vendor IDs over via a lookup

    Adam, Airtable Consultant - thetimesaving.company


    Terms & ConditionsAccessibility statement