Listing out sub category

[Emery_Sheldon]

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.

[TheTimeSavingCo]

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