2. ASPRunnerPro General questions
  3. Help adding table to view
This topic is locked

Help adding table to view

 		3/7/2008 5:01:57 PM
ASPRunnerPro General questions
S
 sleighbor author

Hi guys,
I have just begun using ASPRunner so bear with me if this is a trivial question. What I would like to do is add another table on the view page. The view page is actually a teachers info and under that I would like to add a page that list the classes they teach. I know the SQL query that would have to be run. I just am unsure about adding the table and binding the sql query to it.
Any help would be greatly appreciated!
Thanks,

Kevin
Sergey Kornilov admin 3/7/2008

Kevin,
usually you don't have to run SQL queries manually.
What you need is Master-Details relationship where Teachers is Master table and Classes is Details table.

Master-Details relationship can be set of 'Datasource tables' screen.
S
 		sleighbor author 3/8/2008

Hi Sergey,
Thanks for the reply. I have setup a master-detail relationship for two of my other tables (classes and students) and that worked well. But it seems to me that you can only setup one master-detail relationship on that page. Is that the case or can I set up more?
Thanks,

Kevin
Sergey Kornilov admin 3/10/2008

Kevin,
you can setup any number of relationships on this page.
I recommend to watch "How to setup master-details relationships" tutorial at http://xlinesoft.com/asprunnerpro/tutorial.htm
S
 		sleighbor author 3/10/2008

I will look at the tutorial now and let you know how I make out.
Thank you,

Kevin
S
 		sleighbor author 3/10/2008

Hi Sergey,
I'm not sure if I am missing something here but I can only setup one master-detail relationship for the application. If I try to setup a second it removes the first one that was working.
I have several tables in my database that I would like to setup master-detail relationships for. Is this possible?
Thanks,

Kevin
Sergey Kornilov admin 3/10/2008

Kevin,
did you watch the tutorial?
The second part of of tutorial explains how to build multiple relationships.
S
 		sleighbor author 3/10/2008

Hi Sergey,
I watched the tutorial 3 times. In the end they mention it does not explain how to setup more than one master-detail relationship. I understand how to setup the pairs as they say. They just don't explain how to setup multiple master-detail relationships.
Thanks,

Kevin
Sergey Kornilov admin 3/10/2008

Kevin,
send screenshots that explain your issue to support@xlinesft.com along with your order number.
S
 		sleighbor author 3/11/2008

Hi everyone,
In case anyone is having the same question Sergey helped me to understand how to get around this last night. The issue is that I have a many-to-many relationship between three tables, let's call them A-B-C. Table B has a foreign key for Table A and for Table B. I had setup a master-detail relationship between A-B and wanted to create a second one between B-C. This can not be done with these three tables but it can be accomplished by creating a view of table B. After creating a view of Table B I now have a master-detail relationship between tables A and table B and a second master-detail relationship between table C and the view created of table B. It works great!
Thanks for your help Sergey!

Kevin