When I implement security (option 2-users can see & edit only their own data) the way it works seems to assume that the record was created by the user, and I understand that. However in my application the records are going to be created by an admin but need to seen and edited by a user. The issue is when the admin creates the record it assigns their (the admin's) user id to the security so when the user logs in they see no record.
I can workaround this by creating 3 slightly different applications (one for admin, one for users and one for guests) in different folders all pointing to the one DB but I'm sure there is a better way....what am I missing?