Select a name from another table, populate with key in current table

[Mina_Ozgen]

I think this is a relatively basic request but I could not find an existing post on it.

I have two tables, a child table and a parent table, these are linked via a parent_id. I want an end user to be able to just use a drop-down/search to change their parent using the parent name from the parent table but when you submit the form, it updates the parent_id on the child table.

How do you do this in Appsheets?