Solved

Suggestion Box

Posted on 2000-03-13
4
198 Views
Last Modified: 2013-12-18
I have a Suggestion Box form that has a Document for and a Response form.

I want users to see their suggestions and the responses to their suggestions.  I don't want them to see anyone else's suggestions or responses.  And I want the three people who read and respond to be able to see everything.

any ideas?
0
Comment
Question by:ellem
  • 2
  • 2
4 Comments
 
LVL 1

Accepted Solution

by:
rfharris earned 50 total points
ID: 2614798
Create a computed ReaderAccess field on the suggestion document and have that field inherit to the response docs.  The formula for the ReaderAccess field will need to include the author of the suggestion document and a group or role for the folks who see everything.

I prefer using a role called "[SeeAllDocs]" for the latter group of folks.  This role is stamped onto every document through the computed ReaderAccess field.
0
 

Author Comment

by:ellem
ID: 2620283
Now all I have to do is figure out what to do with your answer.  I have a little dead space when it comes to these reader, author type fields.

use your 50 points for good!
0
 
LVL 1

Expert Comment

by:rfharris
ID: 2620378
I'll provide examples of both fields from one of my active databases later today.  
0
 

Author Comment

by:ellem
ID: 2640254
waiting for your examples...
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now