2. ASPRunner.NET General questions
  3. Managing Lookup Tables from SQL
This topic is locked

Managing Lookup Tables from SQL

 		10/26/2005 4:40:07 AM
ASPRunner.NET General questions
W
 Wisegeek author

Please could you explain the extent of knowledge required to manage ASPrunner effectively. I am concerned that the only way we can use this product properly is with some scripting knowledge. I need something designed for idiots because of the limited time we have to develop our product. We have a basic database with about 40 tables in SQL Server Enterprise Edition. There is no T-SQL manually written. The issue is getting Lookup Tables connected to the fields in the originating tables without writing script i.e we need to give the end user a choice of data values to insert into a particular field with a drop down menu. Like a combo box in Access. Is there an easy way to do this in a wizard.
Also we don't really inderstand how we can get the master-detail relationship to connect our indexes properly so that we can view more than one table at a time on one form like in Access. We are so lost...
Kind regards
Sergey Kornilov admin 10/26/2005

I'm not really sure why do you need scripting knowledge to setup this.
To create a drop-down box proceed to the Formatting tab in ASPRunner.NET and set "Edit as" type for any field to "Lookup wizard". Choose table and field to populate drop-down box. This is it.

More info: http://www.xlinesoft.com/asprunner/docs/lo...okup_wizard.htm
To get more help about any feature just press F1 or click "Help" button.
Master-details relationships overview:

http://www.xlinesoft.com/asprunner/docs/ma...elationship.htm
How to setup master-details relationships:

http://www.xlinesoft.com/asprunner/docs/li...age_options.htm
500361 11/2/2005

I just bought asprunner.net, and agree that the only thing lacking is better documentation. Your noted example on parent/child relationships only shows setting up one parent to one child. Is there anything that shows the whole process of 4 childs to one parent? Any printable docs?
Sergey Kornilov admin 11/2/2005

To setup second (third etc) master-details relationship select next child table on the left and choose the same master table. Repeat this step for next table etc.