2. ASPRunnerPro General questions
  3. MS Access Linked Tables
This topic is locked

MS Access Linked Tables

 		11/18/2005 7:16:43 AM
ASPRunnerPro General questions
D
 dmckeand author

Hi there,
I am trying to webify my Asset Register of all my companies hardware. When I run through the wizard it creates a great web page but all my linked tables are showing the table IDs instead of the actual values themselves.
I have played about with the relationships but with no joy.
Can anyone help me out?
Thanks,
Dave.
Sergey Kornilov admin 11/22/2005

Dave,
you need to use "Lookup wizard" feature or JOIN SQL query to pull data from lookup tables.
If SQL is not your first language here is what you can do.
Proceed to the Formatting tab in ASPRunnerPro and set "Edit as" type for lookup field to "Lookup wizard". Choose table and field to populate this drop-down box. Set ID as a Link Field, field with actual value as Display Field.
After that on List, View etc pages with show actual values instead of IDs.
C
 		Colzie 11/28/2005

Proceed to the Formatting tab in ASPRunnerPro and set "Edit as" type for lookup field to "Lookup wizard". Choose table and field to populate this drop-down box. Set ID as a Link Field, field with actual value as Display Field.

After that on List, View etc pages with show actual values instead of IDs.


I've done this, but my problem is when I click on the column header to sort, the sorting is done by the ID and not the Display Name. Is there a way to have this column sort by the Display Name?
Sergey Kornilov admin 11/30/2005

Dave,
in this case you need to use JOIN SQL query to pull data from several tables simultaneosuly.

Select ID, OrderDate, CustomerID, b.ID as DetailID, b.Quantity as ProductQuantity

from OrderHeader a

inner join OrderDetail b on

a.ID = b.OrderID