Single Page Presentation

Hi,
you can try to join either detail tables in one query (step "Edit SQL query"). For example:

select detail1.field1, detail2.field2 ...  from detail1 inner join detail2 on detail2.id=detail1.id

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=3502&image=1&table=forumreplies' class='bbc_emoticon' alt=':huh:' /> I have tried pasting in an SQL statement for one of the detailed tables in the format you suggest, and ASP runner gives me a "can't retrieve columns"... the problem is that the fields from both detailed tables are not included in the one detail field list just prior to the SQL window. Any suggestions Sergey?

I have found success if I place the SQL statement in the Master table and not in the Detail tables. This makes all the fields from the 3 tables appear in the presentation. Searches work OK, but having problems with Edits on all tables.

Have found that if the SQL statement that is used in the "Master" table was copied from the MS Database equivalent query, after pasting into the SQL Statement window in ASP Runner Pro, you need to edit out the trailing space, and semicolon. ASP Runner Pro will rack up an error message unless you do.
Have also found that this Master table is not exportable, while the Detail tables are.
Other than that, the suggestion of using a custom SQL statement works just fine.