How to set one field value into another field including all child records in location table

raj149
Giga Guru

Hello experts,

 

In location table(cmn_location) i want to copy name(name) value into country and city.

my requirement is 

 

  1. If the Location type(drop down) is Country, than the name must be copied to the Country attribute, including all Child records.
  2. If the Location type is City, the City attribute must be filled with the name, including Child records
  3. Country and City attributes can be greyed out in the Location table because the data is copied from the name only.

 

How achieve this by using script ...?

 

Thanks in advance 

 

Best regards,

Raj.

0 REPLIES 0