I have an inventory form with a locations drop-down, to add a location to a product, which creates the inventory record. Problem is, what if a location is already tied to the product? I would like this Location drop-down (connection to the Location object) to not suggest locations if the link is already there.
As of now, it’s set to “Show all the Location records” for the drop-down. However, is there a way to “Show Locations not yet connected to this page’s Product”?