Page 1 of 1
Copy field value from Master to Detail table
Posted: Tue Oct 11, 2016 9:50 pm
by dire
Hey,
I’m trying to copy field value from master table to detail table (order-> order details)
In table Order, under Client Script->Global->Pages with header/footer->Startup Scrip
$Fld_xx=$row(“Order_xxâ€); //(Order_xx is specific field)
In table Order details, Server Events->Table Specific->Common->Row _Rendered
Order_details.xx=$fld_xx; //(Order_details.xx is specific field in order details)
What is wrong with code?
Re: Copy field value from Master to Detail table
Posted: Thu Oct 13, 2016 11:55 am
by motfs
One is client side variable and another is server side variable. Do not mix up.
Assume you want to paste the value in Master/Detail Edit:
Client side (Client Scripts -> Table-Specific -> Edit Page -> Startup Script):
copy the value (your code) and paste the value (use .value(<value>). Read the Client Scripts -> Startup Script (Example 1) in help file for more details.
Server side:
get the value from master table (use ew_ExecuteScalar("<sql>"))
use Row_Rendered server event to render the value in server side.