MULTIPLE COMMENTS ON A SINGLE RECORD

[BillA]

I have a Continuous Form which shows individual projects. This form is a
product of a search and the Form is not editable (it’s read only). I now
want to include a comments section beneath each project. These comments may
have records, as each “comment†is handled as a separate record with its own
entry date and commenter.

I’ve introduced the comments fields, but if there is more than one comment
per project, the project is listed as many times there is a comment. Is
there a way of including all the comments neatly below a singe instance of a
project record?

Thank you for any advice.
Bill

 

[missinglinq via AccessMonster.com]

"One Record With Multiple Associated Records" means you need the associated
records to be in a subform.

 

[Access101]

If I'm seeing this correctly,

You'll need to set up a One to Many relationship from the PROJECTS to a
COMMENTS table.

The ProjectID would go in the Comments table as a foreign key.

Then you could have millions of comment records for each Project.

 

[BillA]

Hello 101:
Yes you are correct. I note, and have attempted subforms as 'AccessMonster'
suggested, however that nulifies the continuous form look I'm shooting for -
creating single file view.
I'm wondering if there is a way of creating a continous look with any and
all comments (these comments are not very wordy 1-2 sentences).
Thank you for your interest.
Bill

 

[Access101]

The closest thing I could think of is put a button on your continuous form
that opens a form off to the side with the corresponding comments.

 

[BillA]

Access101:
Thanks again for the advice... I'll see if your suggestion will be
acceptable to the end users.
Bill