This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal


Nov 21, 2014, 4:54 PM
4 Posts

@dblookup in section access formula

  • Category: Application Development
  • Platform: Windows
  • Release: 9.0.1
  • Role: Developer
  • Tags:
  • Replies: 1

Hi, everyone.  I wanted know if anyone has any experience using @dblookups in section access formulas.  We have two databases.  A main database that has documents in a particular status and a smaller attachment document database.  The attachments in the second database sit in a field in a controlled access section on a form.  I want to do an @dblookup back to the main database document that corresponds to an attachment document and based on status allow certain role users to be able to edit the contents of the section.  I realize performance might not be great doing this but the attachment documents are really not edited that often.  Has anyone done this type of thing with success and are @dblookups supported in a controlled access section formulas?  I am trying to avoid setting status on these attachment documents based on the status of the document in the main db because I don't want to run into replication conflicts setting status on the attachment documents.

Feb 27, 2015, 3:40 PM
30 Posts
I have also had mixed results using @dblookup in controlled access

Why not make sure you have the same roles in your second db, to match those in the first, with the same groups, thus ensuring that if someone can edit it in the main db, they can in the second


This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal