List related data in Dreamweaver

[juresti]

How do I grab related data in Dreamweaver? I have two tables in Access. I
want to grab a specific title that is of a specific type.

All courses that are of type "Engineering"

I have one Course table with title description etc.

one Type table with all Types which contains a CourseID field that relates to
first table above.

I built a Query in Access it did list only the "Engineering" courses, but in
Dreamweaver the tables do not seem to be linked. I don't seem to have the
ability to grab the name of the course in the first table depending on the
type in the second although they are linked.

Please help.

TY

[juresti]

This is the code I get from Access:

SELECT Courses.Title, tblType.Type
FROM Courses INNER JOIN tblType ON Courses.CourseID = tblType.CourseID
WHERE (((tblType.Type)="EIT"));

[juresti]

I did not get the SQL code to work yet. I selected the Query I created in Access in the advanced recordset Database Items "Views" category and it works. Does anyone have more info on this?