2. ASPRunnerPro General questions
  3. LookUp Wiz
This topic is locked

LookUp Wiz

 		9/25/2004 9:49:06 AM
ASPRunnerPro General questions
A
 AndyS author

Sorry, I do have some troubles with this LookUp Wiz.
Linked information from a different table field appears in the edit mode correctly, but the moment I change to the view or table mode, I retrieve the corresponding AutoNumber value fom MS Access.

Apparently the wiz talks about Linked Field und Display Field which I am in trouble with when trying to display the correct data.

I guess it's me- but what to do ??
Sergey Kornilov admin 9/27/2004

Hi,
lookup wizard settings apply to the ADD/EDIT page only.
To display corresponding values from joined tables on the LIST/VIEW pages.
Here is the sample SQL query that pulls data from joined tables:

Select ID,

OrderDate,

CustomerID,

b.ID as DetailID,

b.Quantity as ProductQuantity

from OrderHeader a

inner join OrderDetail b on

a.ID = b.OrderID


If you like to use joins you need to adjust your SQL query manually on the SQL query tab.
Note: it's recommended to use aliases for fields from joined tables to avoid confusion when two from different tables have the same name.