eyeguy Posted August 3, 2007 Share Posted August 3, 2007 (edited) Can anyone solve a problem that I don't have the expertise to solve myself. I have a diary table and a to do table. They are related by a global in the diary and a user id field in the to do. At present any user can create or view each others to do's by setting the global to the user id. The problem is how can I create a "global to do" that is visible in everyones to do. Second problem is how can I create a "private" to do such that only the logged in user can see. That is that user can not see the other users private to do? Joseph Edited August 3, 2007 by Guest Link to comment Share on other sites More sharing options...
bcooney Posted August 3, 2007 Share Posted August 3, 2007 The problem is how can I create a "global to do" that is visible in everyones to do. You'll need to have a button, "Show All," that sets the global to everyone's ID (global must be text). Use a value list that has all the ids, and set the global to the value list when the Show All button is clicked. Second problem is how can I create a "private" to do such that only the logged in user can see. That is that user can not see the other users private to do? Well, you'd need at least two types of "to dos", private and public. Also, you need to store the CreatedAccountName in each record. Then when a user creates a to do, they'd mark it as private. Then you can use record level access privileges to hide the private to dos from the accounts that didn't create the private to do. Research record-level access. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6238 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now