I need to develop an course site for registration per course (dates) and for each course I will have several teachers assigned to participant.

List of participants willl be fetched from registration table. Super user will have them listed and then he can assign each participant to his/her teacher. Always can update if needed. Also super user can click on the teacher itself and get listed all the participants for that course.

Bottom line:

1. How to GET an drop down field of the teachers in EDITABLE row of the shown table and then UPDATE of that row will hold ID of the chosen teacher from the drop down?

2. How to get a CLICKABLE value in the row field (teacher) which after superuser click on it then it redirects to a new table to show all the participants assigned to that single teacher?

I just found on your demo that question 1 is solved :)

Thanks,

Furthermore, I need all of that to be filtered based on the COURSE which is on specific dates. For that course participants will apply via frontend form (allowing wordpress to store the user details).

Can we talk about that on Croatian (I assume we can understand).

Hi,

I finally started on my project for which I bought your app.

I havea issue. I am showing data from one table and based on the id I show also data from another table (town).

https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/

This field is editable. It means that when user wants to add new line (new student and related info) and when Hometown need to be inserted on the popup window I cant get an values to select based on the foreign key table related.

Ok I changed in the editable column to 'single value selectbox' which now gives what i want.

However, since my towns are from different countries. How to SHOW not only the town (field from related table) but also TOWN and COUNTRY from the same table? Only in the popup list... In the table it is showned already as a two columns...

Ok i understand :) I will use the VIEW

Now I have real issue.

I am using this for the table:

select polaznikid, sifra ,  
ime ,     
prezime,  
godinarodjenja, email    ,
mobitel  , g.gradid,
CONCAT(grad, ", ",drzava) grad, s.spolid, spol
from dvPolaznici p
inner join dvGradovi  g
on p.gradid = g.gradid
inner join dvSpol s
on p.spolid = s.spolid

and i created as said - editable fields GRAD and SPOL with their data and related id keys. In popup EDIT or INSERT NEW row I got this error message as you can see in the screenshot. How to accomplish given?