Skip to main content
juresti
Known Participant
February 16, 2009
Question

List related data in Dreamweaver

  • February 16, 2009
  • 1 reply
  • 293 views
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
This topic has been closed for replies.

1 reply

juresti
jurestiAuthor
Known Participant
February 16, 2009
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
jurestiAuthor
Known Participant
February 17, 2009
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?