Best way to change district field if a specific sub-district is selected?

Hello,

Wondering what the best way would be to auto-populate location fields.

For example. We have sub-districts, that are in a specific district, that are in a specific province.

So it would be great if we can auto-populate the district and province field, once a specific sub-district is selected via a single select field. To avoid human error and extra work.

Is the best way to do this merely a formula field? How does the sub-item field work and would that work here?

7 replies