2. ASPRunnerPro General questions
  3. Look Up Wizard
This topic is locked

Look Up Wizard

 		6/13/2009 9:08:59 PM
ASPRunnerPro General questions
M
 Mwilson91325 author

I use a custom expression [Last Name] + ' ' + [First Name] + ' ' + [employee Number] which displays "Wilson Mark 113" and it inserts "Wilson Mark 113" how do i get it to enter Just to insert 113 into the field?
Sergey Kornilov admin 6/14/2009

Mark,
when you setup a lookup wizard choose employee Number as a link field. This is what actually being inserted into the database.
Please note that on List/View pages you still see your custom expression even though in the database it only stores a link field.
M
 		Mwilson91325 author 6/14/2009

Table: Contacts

Link Field: Employee Number

Display field: [Last Name] + ' ' + [First Name] + ' ' + [Employee Number]
http://demo.asprunner.net/mwilsonmymg101..._Report_add.asp
But i see no list like i do in Supervisors name?
<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=41879&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' />
Sergey Kornilov admin 6/15/2009

Mark,
try this:
[Last Name] + ' ' + [First Name] + ' ' + CStr([Employee Number])
If Employee Number is a number it needs to be converted to text.
A
 		akira_nagasaki 7/28/2009

Mark,

when you setup a lookup wizard choose employee Number as a link field. This is what actually being inserted into the database.
Please note that on List/View pages you still see your custom expression even though in the database it only stores a link field.


how to do that, i means can u give me the code for view as a custom expression?
J
 		Jane 7/29/2009

Hi,
check "Edit as" settings --> Lookup wizard dialog on the Visual Editor tab.