Conditional drop-down menu
I have a Interim table and a contract table. They are currently related by contract number. Most times the Interim slips are created through a portal on the contract side but sometimes an Interim needs to be created without assigning a contract number (to be filled in at a later date) I was able to create a drop down list that shows me all the contracts associated to the particular client but what I would to see is a drop down list that only shows open contract numbers for the particular client.
Thank you in advance for your help!