Hi,
I have form which has five field like below
TV Station Form :
TV Station
Not -01 -- -- (lookup field from Network form)
Not -02 --
-- (lookup field from Network form)
Not -03 -
-- (lookup field from Network form)
Not -04 --
-- (lookup field from Network form)
Screenshot of
TV Station Form view ;
What I am trying to do is to fetch all respective values from the fields --Not-01, N
ot-02, N
ot-03, N
ot-04 to a picklist Network of below form when user select any station name.
Say User Select TV station name is KBEH-TV from Drop down then a script will fetch all related values for instance here should be
Me-TV ,
This TV
ABC
CBS
and if user select WRNN-TV then in the network field should populated only the corresponding values of
Not- 01, 02,03, 04 fields .it should be
NBC
Me-TV
Bounce
DGR
Final Form screenshot:
Can any one please help me how to do that ?
Thanks
Arfater