[Answered ]-How to pull up a value when selecting a value from a list

With Django it is not recommended to use raw SQL for security reasons. It is assumed to be on the web. To effectively manage dynamic choices, I recommend you study the HTMX js library. It sends requests to the server and renders responses in html. It has all the tools to update your choices based on events. Naturally, it does not require refreshing the page.
A little effort to study it, it’s worth it.
otherwise you have to write some javascript code