Sys_choice Table

Display the STATE field of Task table on any other table using type STRING and it should display all choices of STATE field on that reference table.

Open form ParentP1 -> Right click -> Configure -> Dictionary -> then below form will appear -> Select Choice, Choice table and Choice Field -> Click on Update.

 

Then open TASK /Problem table-> You will see the display value of Number field is TRUE-> Then open table TASK because Problem is the Child table of TASK.

Final output will be like this.

 

Ex.3- Create dropdown with your own choices on any table using type STRING.

Sol. Open Form ParentP1 -> Right click -> Configure -> Dictionary -> then below form will appear .

 

Then go to label Custom choices on ParentP1 form -> Right Click on label -> select configure dictionary -> below form will appear -> click on choices tab -> New -> create choices ->click on update.

 

Now reload the form -> you will see output like below.

About the author

Leave a Reply