Skip to main content
Question

Is there a way to have a conditional dropdown select the option if there is only 1 available.

So I have several tables.

Organizations (have many) Contracts
Contracts (have many) Project Codes
Project Codes (have many) Tasks
MMS Codes (have many) Tasks
Work Elements (have many) MMS Codes

When 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.
    This topic has been closed for replies.

    If its only one option just set the default value of this field to the record ID number (or the key value) of that option.
    You have a relationship where 1 Work Element ha s Many Project Codes. Use a combined Text Summary field to float up the Project code to the Work Elements Table.

    Convert it to a text field using the ToText function.

    Then use a form rule to say when the Work Element is not blank and the MMS project code is blank, change the MMS Project Code that combined text Summary Text field.

    .
    I think you can achieve this by using form rules but that would be applicable only for entering the new records into the table using form and not for the grid edit. 
    Terms & ConditionsAccessibility statement