Suggestions for Version 4.x

Thanks for suggestions! See my answers below:

1. Vertical layout on master table info
   
   You can do this already using WYSIWYG editor
   
2. Multi Column drop down list
   
   You can do this using custom display expression (combine two or more fields together)
   
3. Apply totals to several fields
   
   Will have this in on of the next versions.
   
4. A visual SQL designer
   
   Will be added in one of the next versions as well.
   
5. Custom view is basically another SQL query executed against the same database table. I can see two possible problems here:
   

• if you delete this custom view dropdown box stops working
  
• some databases won't allow you to use subqueries
  
  select id, name from (select ... from ...)
  In most cases you can achieve what you looking for using custom display expressions and WHERE clause.

Thanks for the info. I will experiment with them.
Another thought, how about a detail edit matrix where you can move from one record to another without going back to the master list.
JLT
>>>>>

Here are a couple of suggestion for the next version of ASPRunner:

1. More freedom in designing the layout of Master/Detail forms such as the Master info in a concise vertical format and the detail in horizontal format such as:
   xxxxxxxxxxx
   
   xxxxxxxxxxx
   
   xxxxxxxxxxx
   
   (master)
   xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
   
   xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
   
   xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
   
   xxxxxxxxxxx xxxxxxxxxx xxxxxxxxxx xxxxxxxxx xxxxxxxxxx xxxxxxxxx
   
2. Multi Column drop down list similar to MS Access
   
3. Apply total to all seclected fields. Right now, you have to select Total for each field. It is nice that the information is passed on to other total pages but when you have 10+ fields to request a total on a page, that can be time consuming.
   
4. A visual SQL designer; again similar to MS Acess
   
5. To include a table or view in a drop down list, it must be created at the database leve. It would be nice if a view created in ASPRunner could be used for dropdown list.
   Thank you.