help with setting up conditional drop-down
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.
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.
