I have created a form based on a sql table. For the query the Form includes a dropdown list that returns Divisions found in the SQL table. The Run Query successfully returns the data in a repeating table. The repeating table includes a Delete button where I have written CSharp code to delete the data from several different tables.
How would I go about removing the item from the repeating table and updating the drop down list if as a result of the delete there are no longer any items in that division? Is there a way to automatically do a "Run Query" ?