I want to create a field in a module, for example 'Sales order' namely in 'Sales order information'. By default this section has a lookup field that when we select, lets say an account name, the other fields are filled automatically with the account info (like adress, phone, etc). However it is missing a field that I have to create with info I want to have in Sales Order information. The question is, I want this field to fill automatically with the info according to the same field in another module, like 'Accounts'. This field in Accounts is also created by me.

Summarizing, I want to a custom field automatically fills with info from another custom field of another module, when selected an account in a look up field.

Thank you for the support.

Best regards