This topic is locked

Customized Edit/View Form

9/2/2011 5:25:15 AM
ASPRunnerPro General questions
E
ezrow author

Hi,
I have data from a paper form which is stored in many tables in a single database, one of which is a normalized table. What I would like to do is view/edit this form online. I can do it idividually table by table, and for the normalized table, row by row. But, I would like to display the complete form in 1 page or 2-3 pages.
I generated the view/edit form for the first table. How can I use the framework to manually lookup and display the fields from the other tables/rows?

If the framework cannot do it, how can I use basic asp to do it manually inside the view/edit page? Where do I insert the code? What files do I need to consider? If the framework can do a part of the job, which parts? Do I need to do a complete separate page and not build on a generated page.
thanks

Sergey Kornilov admin 9/2/2011

You have several options here.
If your tables are related as master-details you can add/edit master and details on the same page.
If tables are not related as master details you still can add and edit them using a single form however it requires more work. You can check this article that explains how to update multiple tables at once: http://xlinesoft.com/asprunnerpro/docs/update_multiple_tables.htm
Besides that I recommend to check 'How to build advanced webforms' tutorial at http://xlinesoft.com/asprunnerpro/tutorial.htm