database A has documents which should be read also by web users. They have reader access to that db and will open the docs only in read mode. When they try to open a doc in the web, they get a login dialog (so they do not have access).
The reason is an editible (for the admins) dialog list in the form which gets its choice list from database B (dblookup). The web users do not have access to that db.
Which makes me a bit “hopeful” is the entry in the server log: ATTEMPT TO ACCESS DATABASE by was denied
Servername, not Webusers name! But this is confusing: the server has Manager access to database B.
I am looking for “the correct way” to solve this - I know that I can create another webform for these docs which offers that field in a simple text field and not in a dialog list, but that would force me to maintain 2 forms parallel in the future …
The EditingSubform is all the fields as they are now, moved onto a subform.
The ReadOnlySubform is all the fields replated with computed for display fields with their fields changed just a bit… so Firstname becomes Firstname_Display… or whatever
You could use a controlled-access section, instead of subforms, then setup the rules for who can edit or not… search “Creating controlled-access sections of forms” in designer help.