Lookup: List the value if not already selected

PHPMaker General Discussion (PHPMaker)
1

Hi,
I am using a lookup table and have the two fields to select people who are available and who are not.
I have these two fields “Present” and “Away”.
When I select a person in field “Present” then the selected person should not be listed in field “Away” for selection.
How can I reach this?Example:
People: James, Nora, David, Marin, EvaLookup modal table Protokoll:
Present: James, David
Away: Should listed only Nora, Marin and Evampol_ch

2

You may use Lookup_Selecting server event for such case.

3

Thank you for your hint.

But I can not find the solution with help of Lookup_Selecting Server Event.
Could you please help me out here?

Here is the case:
I am using a modal lookup option
When I add a new record then I have two fieldsPresent_People: Lookup-People (Drow Down Selecting) let say 5 persons and two of them are selected
Away_People: Lookup_People (Drop Down Selecting) Then here should I see the rest 3 persons who are not selected in Present_Peoplethanks
mpol_ch

4

Did you mean both fields use Multiple option enabled from Edit Tag pane of your Fields setup?

5

yes.
The following options are in “Edit Tag” checked:
Multiple = Checked
Use lookup table = Checked
Use modal dialog for lookup = Checked
Check duplicate = CheckedAnd here are the options for Lookup Table:

FOR Field “Present”
Table name = view_personen
Link field = Vollname (Jason Maron JM, Kamela Hert KH, Haron Mert HM, etc)
Display field #1 = Vollname
Filter = “'Status = 1”

The Same ist for Field “Away”.
The I will list by field “Away” only the persons who ist not selected in field “Present”…
I even tried to put some code in area of Filter with "Status =1 AND …) but id did not worked.

thanks
mpol_ch

6

You may create another helper table in order to create the relationship between one person and another, and make sure the relation Ids are not the same. After that, you may use Dynamic Selection List.

7

hi,

is that not something with jquery to do?
Because the selected persons (present and away) are not saved in the table.
They are just selected by editig…
A table will not help so much because the selected people for present are not saved to the table…

mpol_ch

8

If the selected people for present are not saved to the table, then how did you define the items for both fields?

9

hi,

I have a table for all the persons in the database.

But I am doing this on flow during the record adding/updating.

I have two button: Present and Away.
For the present the lookup is checking the persons table and selection 3 of 5 from them
After that I am clicking on button Away and select the rest 2 of 5.
Subsequentelly I am saving the record.

mpol_ch

10

It seems your approach is fine.