Dynamically display a column based on Select value

PHPMaker General Discussion (PHPMaker)
1

I have a table NGO. With column NGO and NGO Acronym.
On the search form (Advance form search field ) is a select which is a look up loads all NGO.
My task is to print out its Acronym based on the selected NGO . like Onchnge event should display acronym. In front of the NGO field.

2

You may use Dynamic Selection List. Please read Tutorial - Dynamic Selection List topic from PHPMaker Help menu for more info and example.

3

I understand Dynamic selsction , child look up etc. But the issue i have is diffrent. The challenge is this : display the Achronym of any selected NGO outside the select field. when a user selects an NGO in the search box , print the Achronym on the screen . Thank you

4

You may post your tables schema including some records in it so others could help you straightforward.

5

Table NGOtbl
ID| NGO| NGO_Acronym
1 |DemoNGO| DN
2| DemoNGO2| DN2On advance search form is a look up (select field ) of NGO ( on select DemoNGO from the select , print out DN below the field , on select DemoNGO2 ,print out DN2 below the select field .

6

For such case, then you may use Auto fill. Please read about this from Lookup Table topic of PHPMaker Help menu for more info and example.

7

This works for form inputs but I want it just as plain text. The aim is to show the The Acronym only without affecting the search parameters. Thanks

8

What did you mean by I want it just as plain text. ? Could you please explain it in more detail? An example would be better to understand the goal that to be achieved.

9

The auto fill is working perfectly but I don’t want the auto fill in text input. I want just the string printed out . The pourpose is to display and show more information about the select NGO. Not part of form inputs.

10

Currently, it is not suported to display only in a string without using control element, such as Textbox. However, you may simply set the input textbox as ReadOnly by using Page_Load server event that belongs to the Add/Copy Page and/or Edit Page.

11

Noted ,thank uEven with the input text I can still work with this. The only issue now is that I don’t want the value of the autofill to filter the table in my advance search. (I need it to pop up there but can I exclude it from filtering ?) I tired to use NOT LIKE in the field operator but I still av some rows missing. I would like to totally exclude the auto fill field from filtering but show the same field on search. Thanks

12

I don’t think you can do that.