Force Dropdown Refresh After Closing Related Form (DatabaseJoin and CascadingDropdown)

Hi,

I am facing an issue where dropdowns and other linked elements in my main form (using a database join) do not automatically refresh after I add or modify a related record through the linked form.

Description of the Issue:

  1. I have a main form with a dropdown that uses a databasejoin and cascadingdropdown to fetch data from a related table (e.g., a list of people and families).
  2. In the main form, the dropdown includes an "Add" or "Edit" button, which opens another form to add or modify records in the linked table.
  3. When I close the add/edit form after submitting it, the dropdown in the main form does not refresh to reflect the changes (e.g., new or updated records).

Expected Behavior:

I would like the dropdown in the main form to refresh automatically once the add/edit form is closed, so it displays the updated list without requiring a manual refresh of the entire page.

Request for Help:

Is there a recommended way to force the main form's elements to reload after closing a related form?

Attached Images:

  • Image 1: The main form with the dropdown (and its "Add" or "Edit" buttons).
  • Image 2: The linked form used for adding or modifying records in the related table.
Thank you in advance for your support!
 

Attachments

  • 1733989046239.png
    1733989046239.png
    6.4 KB · Views: 57
  • 1733989074680.png
    1733989074680.png
    59.1 KB · Views: 60
It should do (at least it was working at some point for dbjoins).
Or are your elements in a repeat group? There are still issues.
 
Hi,

Thank you for the assistance so far. I wanted to ask if there is a specific JavaScript command or method that I could use in one of the elements (perhaps triggered via a keypress or another event) to force a refresh and ensure the elements update accordingly.

If such an approach is possible, could you please provide an example or suggest the best event to use for this?

Thanks again for your help!
 
Back
Top