Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have the list box1 it contain product, salesman and area this list box content are loaded by In-line script.
if i select the product in list box1 i want to show the list box of product (it is another list box)
if i select the salesman i want to show the list box of salesman (it is another list box)...
How can i achieve this help me
Thanks in advance
Stephen,
You have to follow the reference manual for triggers.
Actually how it works is we set action for a field. Let there be Inline Field as Field1. Here Field1 has value Product,SalesMan and Area. Now you also have separate fields as
Product = Values of product can be Shirt,Belt etc
SalesMan = Ram,Jhon,Rahim etc
Area = Delhi,Bombay,City road etc
You have called these fields in separate list boxes. Now you have ListBox with Field1 which has 3 values Product,SalesMan and Area. Now in triggers you have to write action. use External action"Set Variable'
Create a variable vListBox (you should know how to create).
In actions value expression write:
if(getfieldselection(Field1)='Product',1,if(getfieldselection(Field1)='Area',2,if(getfieldselection(Field1)='SalesMan',3)))
Now on each List boxe for Product write Show conditional as
if(vListBox=1,1,0)
Now on each List boxe for SalesMan write Show conditional as
if(vListBox=3,1,0)
Now on each List boxe for Area write Show conditional as
if(vListBox=2,1,0)
Just use trigger on Fileds.
-Go to >> Document Properties
- Triggers Tab
- Go for the required field in Field event Trigger
Then you can write the action on On Select to activate each List boxes.
So, you want to see related data for one selection in one list box in another list box, then we need to join the tables as per our requirement.
Once see the data model may be tables may not be joined if at all 3 fields were from 3 different tables
can you explain about detaily
try to use trigger on select to show list boxes
Go to Document Proprieties select Triggers and select your field name (witch you want select field) in field event triggers, click on "On Select" Button.
Select Add->layout->Active Object and Give Object ID(witch you show list box ID)
if I understand, see attachement
not one object based on selection i want to show the list box
i am using trial version can you share the procedure
Stephen,
You have to follow the reference manual for triggers.
Actually how it works is we set action for a field. Let there be Inline Field as Field1. Here Field1 has value Product,SalesMan and Area. Now you also have separate fields as
Product = Values of product can be Shirt,Belt etc
SalesMan = Ram,Jhon,Rahim etc
Area = Delhi,Bombay,City road etc
You have called these fields in separate list boxes. Now you have ListBox with Field1 which has 3 values Product,SalesMan and Area. Now in triggers you have to write action. use External action"Set Variable'
Create a variable vListBox (you should know how to create).
In actions value expression write:
if(getfieldselection(Field1)='Product',1,if(getfieldselection(Field1)='Area',2,if(getfieldselection(Field1)='SalesMan',3)))
Now on each List boxe for Product write Show conditional as
if(vListBox=1,1,0)
Now on each List boxe for SalesMan write Show conditional as
if(vListBox=3,1,0)
Now on each List boxe for Area write Show conditional as
if(vListBox=2,1,0)