Create Mail Route DFF and Link to Manage Location

Summary:

Create Mail Route DFF and Link to Manage Location

Content (required):

We have a requirement for Mail Route to be dependent on Location. However, currently, Mail Route is not an LOV field, but a free text field. So I am thinking to create a DFF that will be dependent on locations (Manage Locations) however, I am not quite sure if this is possible.

our initial solution is to use Autocomplete rules, but if the mail route and location is 1 is to 1 then we will have a problem if we will have 1000 location and more as this will have an impact on performance and we need to update always the autocomplete rule every time that we have a new location or remove a location.