I’ve struggled with this for a while, so I thought I’d pick the Masters brains here to see if you all know a way. In my inventory system, I create Purchase Orders regularly for different Vendors. I first select the Vendor (Manufacturer), then I add Products to the Purchase Order. How can I only show Products that contain this Vendor in the multiple choice list?
This image shows the Vendor already at the top, from the Parent page of the Form. But it shows ALL Products from the Products database. Each Product is connected to one Vendor, so you’d think there’d be a way to restrict this to only show those? Perhaps I need to somehow connect Product to the Vendor? Since Vendor is in the main PO, but the Product is in the “PO Line Items” table?
If you change the Vendor from a multiple choice field to a connection field to a new Vendor object, then you’ll be able to filter the Products dropdown to the Vendor that the current PO is connected to.
The problem is the Vendor is connected to one Object - “Inventory PO”, but the Products go into a sub-Object called “Inventory PO Line Items”, which isn’t connected to the Vendor. I created the Vendor object and connected it to the Inventory POs, but its still not showing as an option to filter by. I have the Products object connected to Vendors now too.
All of the Connections are One-to-many. Vendors, Products, Inventory POs, and Inventory PO Line Items are all connected to each other. I even added the Vendors Connection field to the Inventory PO Line Items too, and re-made the form shown above to be:
