2. ASPRunnerPro General questions
  3. Data from second table
This topic is locked

Data from second table

 		3/24/2005 10:12:21 AM
ASPRunnerPro General questions
M
 megaboo author

I have a large database with products that I want to list. Each product has a CHASSIS_ID wich links the master table with the CHASSIS table. The second one has 2 fields: CHASSIS_ID and CHASSIS_NAME.
I want to list the master table items like this:
NAME | COMPANY | CHASSIS_NAME
and not like
NAME | COMPANY | CHASSIS_ID
meaning that I want the value from the second table to be visible in the list...
Thanks in advance
Mikhail
Sergey Kornilov admin 3/24/2005

Hi,
you can do this using ASPRunner Pro 3.1a.
In the master table set Edit as type of CHASSIS_ID field to Lookup wizard using CHASSIS_NAME as display field.

After that CHASSIS_NAME will appear on List/View pages.
M
 		megaboo author 3/24/2005

Big problem... I was on try period and upgrading to 31a just locked me out... I tried it with the 3.1 version but the field you suggested was not editable...
Anyway thanks
Sergey Kornilov admin 3/25/2005

Hi,
to make this field accessible you need to select the Key field and create the Edit page.
If you don't need Edit functionality create the query/view that pulls data from both tables.