populate data from another table fields

[VSN]

I have 2 tables, 

1. program , it   contains portfolio and sub-portfolio

2. Change request, it contains portfolio and sub-portfolio,

common number between teo tables is  project number field 

here , i need to get value from porject portfolio to change request portfolio.  

i have written script include and client script , but it was displaying the after form got saved, but i need to display the portfolio and sub-portfolio values for new form.

script include:

Client script:

[Anurag Tripathi · Accepted solution]

Hi,

You need to change your client script from onload to onchange, and make it run onchange of u_program_name field.

[VSN]

But I need values for new record 

[Anurag Tripathi]

It will work for new record as well. When you add value to the field it will run.

[Upender Kumar]

As suggested by Anurag, change the client script from onLoad to onChange of u_program_name field.

Now if the record is new then there is no value in u_program_name. That's why your script is not running onLoad.

Either you set a default value of u_program_name to run the script onLoad. But if you will change the value of u_program_name field before saving, it will not update the fields.....