Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Listing out sub category

1069 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Emery_Sheldon
5 - Automation Enthusiast
5 - Automation Enthusiast

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