I have two separate databases one called Prisons and one called Prisoners.
I want to update the Prison address in the Prisoners database by clicking a button "Update" or letting it automatically fill in.
I thought I would need a script with Set Field to bring in all the relevant address info into the Prisoners record when I select the Prison name from the drop down list in the prisoners file. It doesn’t have to be done with a button, auto infill would be good too when the prison name is selected.
Can anyone give me an example for the script to do this and any other changes I would need to make to the relevant fields that need to be filled in.