Is ti possible to autopopulate territory based on state field?

States And Regions ~ Add New Record
https://haversineconsulting.quickbase.com/db/bm6zr9qak?a=nwr

Pastie Database
https://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=609

Notes:

(1) The States and Regions are unlikely to change short of a new government forming or a change in your Sales Regions so there may not be any good reason to store the State or Region data in one or more related tables. Doing so will just crowd up your application with superfluous fields and tables.

(2) Using table relationships would coerce historic data to map to new states or regions when this probably is not the desired behavior.

(3) This is a very generic solution that can be adopted to any type of lookup scenario.