Michael, I've been working on this a little more and I believe I have it a little more user/admin friendly. I'll combine my prior post with this one:
First, the author/reader option appears to work well. On the "web" versions of the MainTopic and Response forms, there is already an ApprovedReaders field. I took the code out of that one and re-used it in my "Approve" button that I added to the Notes form.
My approve button is:
Lookup := @DbLookup("Notes":"NoCache"; ""; "(LookupCategories)";Category1; "AuthorizedReaders");
@If(@IsError(Lookup);"";Lookup);
@SetField("AuthorizedReaders";Lookup);
@SetField("Posted";"1");
@Command([FileSave]);
@Command([CloseWindow])
What I did to get here besides the readers field change was to add a CWC "Posted" field on the MainTopicWeb and ResponseWeb. This defaults to "0". As seen above in my approval code, I change that field to "1". In all of the web views (I believe I got them all) as well as the WebBoardIndex view (used by the WebBoardIndexSchedule agent, I added to the end of the View Selection Criteria the following formula: & Posted!="0"
In my Notes views for Admins, I have added a column displayed as an icon with the following formula: @If(Posted="1";82;80)
This works great in my testing. Michael, if you want a copy of the database, let me know. I'm not sure if this is exactly what you wanted to go for with the 1.2 template or not…. AIM me at whisonantc