2. PHPRunner General questions
  3. [SOLVED] Maintain name order in a table
This topic is locked
[SOLVED]

Maintain name order in a table

 		11/26/2022 12:07:02 PM
PHPRunner General questions
I
 I author

Hi everyone, I want to add some names in a "members" table. You can choose these names from the table "names". For this I use a "lookup wizard". See photo3.
As can be seen on photo 1, I choose the names in this order:
name4, name2, name3, name1
But if afterwards the record is saved in the table "members" then you can see that the order has been changed (see photo2) ...
How can I ensure that the order appears in the table as I have chosen the order as entered in photo3?
Can I use another method for this? Any suggestion is welcome, thank you.

img alt

img alt

img alt

admin 11/26/2022

You cannot make it work this way. If you need your entries to be ordered you also need to save an additional value, the order of the entry. The regular multi-select control won't help you here.

I
 		I author 11/26/2022

thanks for the helpful tip