In the picture below you will see two areas I need help with. The first starts with the drop down titled Substitute Trustee followed by three form inputs that display related information. The data set is set to read or write. The drop down is connected to the data set that shows all the property info and the drop down list is connected to a data set of trustees. What I want to happen is if I change the trustee in the drop down it will auto fill the info in the other three elements to the right. The next area is the form below titled Add New Trustee. This is where I can add a new trustee to the trustee database. Problem is when I do that I need to refresh the page for it to show up in the drop down list of the first form I mentioned. Is there away to have it refresh the list so I do not have to refresh the page once the new trustee is submitted.
Again any help would be wonderful.