2. ASPRunnerPro General questions
  3. Related Tables
This topic is locked

Related Tables

 		1/30/2005 9:30:50 PM
ASPRunnerPro General questions
R
 Robert author

Hi...it's me again.

I'm very satisfied with what I've seen and done with ASPRunner....that's why I've always got questions...
Take as an example that I have two tables which are related: Orders and Customers. On the Orders table there's a field CustomerID.

What I can't manage to do is create a list of Orders where the customers name appears and not the customers ID. Of course I want to allow editing and I can just have that available if I use the Orders table (showing the ID) itself. If I use an Access Query (which would show the customers name) edition is not available.

Thanks in advance once more...
Robert
Sergey Kornilov admin 1/31/2005

Robert,
in ASPRunnerPro 3.1a you simply need to define CustomerID in orders table as a lookup wizard field with Customers table as a datasource. In this case corresponding customer name will appear on list, view, print and export pages.
R
 		Robert author 1/31/2005

ok...great...but SEARCH doesn't find the name from the lookup table...

Another suggestion: Let the version show entirely on the title bar (I am not sure 3.1a is installed - it just shows 3.1)
Sergey Kornilov admin 2/5/2005

Robert,
In ASPRunnerPro v. 3.1a you can build an advanced search page where users can pick a value from the drop-down list. In this case search for lookup fields will be working as you expect.