2. ASPRunnerPro General questions
  3. list view ....
This topic is locked

list view ....

 		3/22/2010 7:23:18 PM
ASPRunnerPro General questions
K
 kcrozier author

Hi,

I'm still a relative newbie to using ASPRunner, so forgive me if the answer to my post is simple ... But here we go ...
I have two tables, Team which contains a list of teams numbered 1 through 10, the second table is the schedule with weeks 1 through 18 and 5 games each week. The schedule table has the following format
week

game1home

game1away

game2home

game2away .... etc i think you can get the idea.
In game1home is the number of the team that will be at home, and game1away has the number of the team that will be the away/visiting team. So let's say the values are 1 & 10.
What I would like to do, is have the list page show
week1 Duke vs Alborz
what i get is
week1 1 vs 10
Is this possible to do ?
TIA

Ken
Sergey Kornilov admin 3/23/2010

My suggestion is to setup fields game1home, game1away etc as 'Lookup wizard' choosing Team as datasource table and real team name as a display field. You can do this in Visual Editor. Double-click on field to access 'Edit as' settings.
K
 		kcrozier author 3/23/2010

Thanks, I had thought of that and tried it, but it makes it a drop down box which i don't want .... Is there any way to turn of the drop down feature in the lookup wizard ?
Sergey Kornilov admin 3/23/2010

Not sure I understand how list page in original question and dropdown boxes are related.
Probably you can elaborate or better yet post your app to Demo Account and post the URL here.
K
 		kcrozier author 3/23/2010

Thanks, i got it .... I was confused by the 'TEST' button on the lookup wizard and what actually appears on the page ....