Hi all,
I need a solution for this idea:
- I have a table "assignments" with 2 fields: pos_id, user_id
- I need a table on my form which displays the dropdowns for both fields with the data stored in the database.
- The user id possible values are from the users table (jos_users or its name), the pos_id is from my custom table (positions)
Is there any way to achieve it?
And of course a submit button with save into database would be good as well.
You can have 2 dropdowns loading values from tables users and positions, please check this tutorial:
You need to use the Read Data setup
Thank you for your answer, I know how to fill up data for dropdown options. What i really need is to read data from the "assignments" table first and populate its values (it can be 1 to 8 rows). to lines with dropdowns for pos_id and user_id (stored in the assignments table)
You can read the data then:
1- use PHP in a PHP actions to create your own array then:
2- use that array for the options in the Dropdown
#2- is explained in the tutorial I linked before, do you need help with #1 ?
