So I have several tables.
Organizations (have many) Contracts
Contracts (have many) Project Codes
Project Codes (have many) TasksMMS Codes (have many) TasksWork Elements (have many) MMS CodesWhen I am on my Tasks table, I select the organization, then (via conditional dropdown) I select the Contract, next I select the work element then (via conditional dropdown) I select the MMS Code. At this point I am ready to select my project code; however, I am EVER going to have one option (the correct option). Is there a way to have this final dropdown select the project code automatically since it will be the only option available in the dropdown?
Because of what this information is, we have to implement the process of selecting a Work Element and then MMS Code.