So basically I am looking to have a portal in a popover button that is on every layout. The portal needs to display records from Invoices and filtered by shipping status. Basically a quick look at the current orders shipped or waiting to ship. Big problem is when I am on a Layout based on a table that is related to Invoices. I tried another Invoices TO I tried a cartesian relationship. Tried many things. It will only show me related records of the record I am on.
I tried using Execute SQL in a few ways but that did not work either.
I am sure there must be a way to get this done.