I'd appreciate any help. I'm a new user of PHPRunner.
I have a database with a family table and a children table, related on family_number.
Username and passwords are stored in the family table and I'm trying to use that to restrict access to allow the logged in family to edit only their family record and only their children records, but to be able to view all records.
The master/detail is working correctly, displaying the correct children for each family.
When I had Advanced security options set to "See other user's data, can edit their own data only" it worked correctly on the family (master) level, but allowed me to edit any children (detail) records.
Then I set up 2 separate projects - one which allowed only viewing of all records by anyone on login. Of course that worked fine. I had a 2nd project that I wanted to use to allow members to edit only their family/children records, so set Advanced security to "Users can see and edit their own data only". That project correctly pulls up only their own family/children records, but has no edit links at all.
I'd prefer to do this in one project, but the 2 project approach is better than nothing. I can't get either to work.
Is it okay to have the login info in the family table or should that be in a separate login table? I broke it out and tried it in a separate table and it didn't seem to make any difference.