Many-to-one problems

I have a “PartnerInfo” table with a field “region_full_name”,

I hope to be able to select a piece of data from the table “Region” when editing this field.

And use the “full_name” field, and at the same time save the value in the “region_full_name”,

When displaying, directly display “region_full_name”, what should I do?