
	Home > Domino Tips > Administrator > Database > Return Multiple Values For A Single Look Up

Domino Tips:

EMAIL THIS

TIPS & NEWSLETTERS TOPICS

DATABASE

Return Multiple Values For A Single Look Up

Neil Gower

02.10.2000
Rating: -4.00- (out of 5)

Digg This!

StumbleUpon

Del.icio.us

Quick and Dirty !

I often find that I wish to use PickList to return more than 1 value from a
view. You can do this with subsiquent DBLookups, but there is a relatively
simple way to do it using PickList.

Create your view with the columns you require. Then create another column which
contains all the values you wish to return, separated by unique identifiers.
Make the text color of this column the same as your view so the user does not
see it in the pick list box (set width to 1 as well).

Now you can use PickList to return this string, and use @left and @right
functions to get the seperate values.

This has worked on many occasions for me.

Code

e.g

Value:=@PickList( [Custom] : [Single] ; ""; "(Vacancy Type Definitions)"
;"Vacancy Type" ;"Please Pick a Vacancy Type" ; 2 );

VacDefUNID:=@RightBack(Value;"!!");

VacType:=@LeftBack(Value;"!!");

@SetField("Vacancy_ProcessUID";VacDefUNID);
@SetField("Vacancy_Type";VacType)

Rate this Tip
To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database
	LotusScript code rebuilds corrupted busytime.nsf file
	How to move Notes databases off Domino 8 servers and save disk space
	Top 10 Lotus Notes/Domino administration tips of 2008
	Batch file runs scheduled Lotus Notes database maintenance tasks
	Fix and update Lotus Notes documents with limited access
	Programmatically replace the design of Lotus Notes databases
	Add a program doc to compact Lotus Notes databases automatically
	More efficient local Lotus Notes database replication
	Remove orphaned Lotus Notes documents on Domino databases with a 'virtual delete'
	Detect and fix 'Manager' access control list settings in Lotus Notes Domino

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Domino & Lotus Notes Security Solutions: Authentication, Antispam, Encryption and Antivirus

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy