6 Replies Latest reply on Jun 11, 2010 1:34 PM by lloyddd

    Show All and



      Show All and


      This database tracks events.  EVENTS in planning can be confirmed and unconfirmed and then confirmed again in a matter of minutes.  As a result I have set it so that an EVENT can be archived which sets field


      EVENT::EVENT_ARCHIVE to "archive" 


      The access for the privelage set is set so that

      EVENT::EVENT_ARCHIVE = $$archive


      This allows me to remove an event and all of it's associates in an out of view with ease without having exporting the record to a duplicate database.


      My problem is when I archive an EVENT the record shows <<NO ACCESS>>, as it should; however I don't want to see this.  I understand that running any find will get rid of all <<NO ACCESS>>  records; however, I want to preserve the found set and the sort order.


      Is there a way to achieve this other than creating a dictionary and looping thorugh find requests?