2. ASPRunnerPro General questions
  3. lookup table wizard
This topic is locked

lookup table wizard

 		6/18/2007 10:18:10 AM
ASPRunnerPro General questions
M
 mstx04 author

Hi
is it possible to set the Display field in the Lookup Table wizard to concatenate columns from two separate tables? Is there another way of doing this than to create a view that joins the tables?
BR
Mikael
Sergey Kornilov admin 6/18/2007

Mikael,
in current version of ASPRunnerPro you cannot build a lookup wizard based on more than one table.
Use a view in the database for this purpose.
C
 		ccuser 8/17/2007

How about in PHPRunner 288?

I can create a view from within PHPRunner with the data I want from 2 tables but the view does not show up on the list on the lookup wizard?

Is there another way?

Mikael,

in current version of ASPRunnerPro you cannot build a lookup wizard based on more than one table.
Use a view in the database for this purpose.
Sergey Kornilov admin 8/17/2007

If you need to build a lookup wizard that pulls data from two tables build a View in MySQL or a query in MS Access and use it as a source in ASPRunnerPro or PHPRunner.