Just discovered a security issue on record ownership...
In a project, I have several tables...where in most cases I am assigning ownership based upon a field called CLASS
To allow employees to be able to update their own passwords, I built a query and attempted to give ownership to that record by setting the users and main table to LoginID
What I discovered is that no matter which concept I use on one table, the security on the users portion of screen 7 is adjusted for ALL tables. So it doesn't seem to allow me to set up one table on one set of circumstances of security and another on another set of circumstances.
Can you tell me how I can separate this based upon tables? Reference Page 7 of the project..Advanced Section USERS TABLE field verus MAIN TABLE field.
Thanks
Steve Divine