Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
use values from other databases
- Thread starter harryus
- Start date
Hi Harry,
you can use the @dblookup function to get values from other databases. The values have to be listed in any view (hidden or not) in names.nsf. Otherwise create a new column in an existing view or design a new view in names.nsf.
Example:
"viewname" can also be the alias of the view.
"key" is the search criteria for the first sorted column of the view.
"column" is the number of the column which contains the desired value.
The @dblookup will return a list if more than one document matches the criteria. Get the desired value by @Subset.
you can use the @dblookup function to get values from other databases. The values have to be listed in any view (hidden or not) in names.nsf. Otherwise create a new column in an existing view or design a new view in names.nsf.
Example:
Code:
@dblookup ("":"NoCache"; "yourserver":"names.nsf"; "viewname"; "key"; column)"viewname" can also be the alias of the view.
"key" is the search criteria for the first sorted column of the view.
"column" is the number of the column which contains the desired value.
The @dblookup will return a list if more than one document matches the criteria. Get the desired value by @Subset.
- Status
Similar threads
- Locked
- Question