Hi,

I am creating a listing of documents in ASP that contain the Title of the
document and its authors. In Access I created a table for the documents
(title, number, etc.) and one table for the authors. Also I created another
table that connects the two since there are documents with more than one
author and authors that have more than one document.

The problem I am having is creating a Master Detail Page Set in following
format:

Document Number 1, Title 2, Authors
Document Number 2, Title 2, Authors

I don't know if I have to create a special recordset or a query in Access.
I created a Query but it doesn't work in UltraDev, one of the tables records
don't show up.

Many thanks for any assistance,

Ed

create the query again in access, then right click on the query and goto SQL view.
copy the sql statement.

in your open recordset in ud, goto advanced and paste the sql statement

your answer lies in a inner/outer-join

<img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>