Information Technology Reference
In-Depth Information
We have to set up the relationship between the ID field in the USER table and
the USERID field in the COMMENTS table. Pull down the Tools menu and select
Relationships … . You should see a list of the two tables. Add both tables and close
the panel. Then click on ID in the USER panel, and drag to the USERID in the COM-
MENTS panel. A line will now extend between them showing the relationship.
Then create the query, using the Create Query in Design View tool. Again add
the USERS table and then the COMMENTS table and close the panel. Then
select in order the USERS.FIRST, USERS.LAST, COMMENTS.TIME and COM-
MENTS.MESSAGE fields.
