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.
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