Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » RADICORE development » Application Development » Help/suggestions with record filtering by user
Help/suggestions with record filtering by user [message #1435] Wed, 09 July 2008 15:45 Go to previous message
bonzo_bcn is currently offline  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?


 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Next Topic: Problem with two list1 transactions on one table
Goto Forum:
  


Current Time: Sun Apr 28 00:20:30 EDT 2024

Total time taken to generate the page: 0.01060 seconds