Hi,
I have a form and which has several fields but two fields are
TV station and
Market (
Market is the lookup field of market Form).
below is the data format.
I am trying to update this form data by using another stainless form.What I am trying to do is put a
Market field drop down above on the stainless form and when user select the market name from drop down then a script will run to retrieve the related TV station name in the next tv station drop down field.
For instance , if user select "Market1" from Market drop down field then in the TV station Field only show , TV1, TV2, TV3 .
I have tried the below code but not working:
********************************************************
clear TV_Station_Name;
net = TV_Station [ ID == input.FilterMarket];
TV_Station_Name:ui.add(net.TV_Station.getall());
***********************************************************
Stainless form:
Could you please help me to fix this.
Thanks
Arfater.