Hello.
On my table for jobs, I have selected user can see and edit own data only. But in the table, there is no username as there is in the login table.
If I creat a field called username in my jobs table, I need to fill this with whoever logs the job
How can I get the current username to be put into the table so it will log who has entered the job and then the permissions will allow me to select user can only see and edit there own data in the security settings?
At the same time, Admin need to be able to see everything.
Cheers
Paul