I have a database for reporting productivity.
There is a managers table and a users table.
The managers table contains entryid, username, date, productivity.
The users table contains username, password, firstname, lastname, email.
I'm creating a project for managers to enter their productivity into the managers database.
At the end, of the setup, under "Advanced security settings", I've selected the option to allow users to see and edit their own data only. I've also defined the owner id fields for the managers and users table.
I've selected the box that says "Add admin user that can see and edit all users data". However, when I try to select a name from the drop down list it doesn't display any names.
I've updated to the latest build of PHP and tried turning off my firewall, but it seems that for this field it's not pulling the data from the table.
All other dropdowns seem to be working well.
I did a search before posting this and found directions to create ownerid fields using integers. Is this something I have to do, or can't the username fields be the defining ids?