Help

Listing out sub category

50 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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 1

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