Auto-fill column from child table if exists, else allow manual input

[Boray]

Hi everyone,

I have a case where I want a column’s value to automatically pull from a related child table (store) if the account has a related store. However, if there’s no child table, I want the user to be able to manually edit the column.

Additionally, if the account later gets linked to a store, I want the value from the store to overwrite any value that was manually entered before.

Is this possible? How can I achieve this setup?

Thanks in advance for any guidance!