I want to set the terms field on a Sales Order depending on the customer that the user selects, based on the field terms that is on the customer record, but the thing here is that the way we have set the customer record is a

parent->child

relationship so the payment terms field is on the child record of a customer, so when we select

customer 1 (parent)

, the billing -> terms should be set with the value payment terms that is on the customer child record, I tried doing this on a Workflow but It only works when I select the

static value -> selection

option, when selecting the opction

from field

->

record (join field) : customer

field: terms

it doesnt work, is this something that can be done with a workflow or should I use a script for this purpose?