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.
Subject: 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