help with setting up conditional drop-down

Question

So I'm trying to set up this conditional drop-down but having no luck. I think some of the relationships between tables are wrong maybe? The application has been worked one by multiple people at different times so its a bit messy.

So here is a break down of the tables that i want to relate in regards to the conditional drop down.

Cost Codes(CC): how accounting keeps track of what money was spent on
Vendors: people we contract out work to
Purchase Orders(PO): work that a vendor is hired to do

So when i make a vendor I select different CC they are associated to

and when I make a PO I select what vendor it is to.
I want the conditional drop down here so I see the 4 or 5 CC that I selected in the Vendor on the Vendor table instead of all 400 CC.

vijaysingh · Answer

I think you would be able to do so on the Form and not during the Grid Edit. You can create 2 separate multiple choice fields in the table and list down the values as needed by PO and Vendor choices. On the form you have to use the Dynamic form rules to chose the list depending on the PO or Vendor selection to be shown for the users to select their input..

Sign up

Login to the community