Categories

[Tamara]

Hi all,

I have made a Table of contacts and their contact
details. I would now like to put these contacts into
categories (groups). Back in 2000, I created a database
and I remember being able to group entries into
categories. I have been all over Access this morning and
I can't seem to find how to do this. Can someone please
refresh my memory? Thanks.

Tamara

 

[Arvin Meyer]

Add a table with groups something like:

tblContactGroups
GroupID - Autonumber - PK
GroupName - Text

Then add a column in your contacts table for the GroupID. Add the GroupID to
any queries that require it for reports, and build a combobox on your
contacts data entry form for choosing the group each contact belongs to.
There is a wizard that will guide you through adding a combobox to your
form.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access