two tables that are linked together

C

ChuckW

Hi,
I am a novice access user who is looking at someone else's application.
They have a Post Table and a Comments table. There is an id field in the
Post table that links to a Post_Id field in the comments table. When I open
the Post table, there is a blank field on the far left that has a plus or
minus sign. If I click on the plus sign, it appears to open values from the
Comments based on these two fields. In the Post table there is a Body field
that has information that people have typed in. In the Comments table is
also a Body field that has information. This access database comes from an
offline copy of a web site application. A user on the website creates a Post
which feeds into the Post.Body field. Someone else will then add a comment
to that post which feeds into the Comments.body field. What I want to do is
to create an Access report that has both the body sections from both tables
(The post and the comments from each body field). Can someone tell me how to
do this?

Thanks,
 
M

MikeL

If you look at the properties of the Post table. How is the table property of
'SubDataSheet Name' set?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top