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.