ACCESS 2007, want to create comment/remarks section.

[MusicFan381]

To any MS ACCESS 2007 users: I'm using a Contact List Database and there
should be a plus sign to the left of each record that acts as a toggle to
open and close a comments section for typing the results of each phone call I
make. Does anyone know how to add this feature to an existing database?

 

[John W. Vinson]

To any MS ACCESS 2007 users: I'm using a Contact List Database and there
should be a plus sign to the left of each record that acts as a toggle to
open and close a comments section for typing the results of each phone call I
make. Does anyone know how to add this feature to an existing database?

Ummmm...

Don't.

You should NOT be using table datasheets for interaction with your data. Use a
Form (for calls) with a Subform (for comments) instead. Table datasheets have
limited functionality; Subdatasheets (the misfeature you're proposing) can
really kill performance of your database.

If you want to do this anyway, open the calls table in design view and set its
Subdatasheet property to the name of the comments table. This will only work
if both tables are local, not linked, and if there is a Relationship defined
between them (which there certainly should be, if there's not already).

 

[MusicFan381]

John, Thanks for your reply. I created a form from my table data sheet. I am
following advice from the "ACCESS 2007 For Dummies" book.

I only have 9 entries so far that I entered prior to creating the form.
Before creating a subform, I assume that I have to create a primary key and
then set up relationships. What does it mean when the primary key option
doesn't appear in the ribbon in Design View? Does that mean that there is
already a primary key assigned?

I've used ACCESS with my previous employer but was never involved with the
design or building of databases.

Thanks.

Bob.