Hi,I’m new with Lotus Domino Designer.
The situation:
I got a dialog list field “name”, which refers to a view “customer” with a @DBColumn. After choosing a name, I want that in another field “adress”, the adress of the customer is shown.
The information is in the view “customer”.
In the first column “name”, the customer’s name is shown. It’s categorized ascendingly.
The second column “adress” of the view displays the customer’s adress. This information should be shown in the field "adress.
TIA
Markus Oeynhausen
Subject: RE: @DBLookup
It’s not hard to use an @DbLookup to retrieve the information. Set the keyword field option to refresh fields when the keyword field changes.
You haven’t said whether the address field is editable. If it’s computed, the @DbLookup can just go in the computed field formula. Don’t forget to check for a blank ‘name’ field – don’t waste your time looking up the key “”. Also, use @IfError to avoid error messages if the lookup fails.
If the field is editable, you can use @DbLookup in the input translation formula, but then you have to think about when you want it to change. If the user changes the address, you wouldn’t want to overwrite it with the wrong address from the lookup record. But if they select a different name, perhaps you want to replace the address with the address or that name. You might have to have some hidden fields that remember what the Name or Address field was last time it was calculated, so that you can tell whether the name has actually changed or whether the user has edited the address field.