Add Filter to No. in Sales Line Base on Another Table

We have Vendors that only allow customers to buy their products when they submit paperwork. I have setup a field called "Restricted Line" Boolean in the Vendor table and I've created a tabled called "Customer Authorizations" where Customers are tied to Vendors when they are authorized to sell their products.

I'm trying to find a way to filter the "No." field on a sales order to only show items where the customer is authorized. I have a flowfield set on items that say when its restricted based on the vendor.  All items are only sold by one vendor.

Related
Recommended