Help/suggestions with record filtering by user [message #1435] |
Wed, 09 July 2008 15:45 ![Go to next message Go to previous message](/theme/default/images/down.png) |
bonzo_bcn
Messages: 152 Registered: June 2008
|
Senior Member |
|
|
I have table called 'people' that stores personal data (name, address etc.).
This table is filled by two types of users: schools and super_schools.
Each school should only be able to see the persons they have created, super_schools must see all records.
One same people record can be created by many schools: in this case the first one would do an insert and the following transactions would do nothing (or maybe update), but the second and third schools should also be able to see the 'people' record.
What do you suggest for this scenario?
|
|
|