I'm trying to create some kind of database where I can enter the
customer's
name, address, phone and email...but I want to be able to pull out certain
groups of customers for a mailing list...such as Special Groups Committee
or
the Foundation Group.
Make a CustomerGroup table like this:
CustomerGroupKey Autonumber, Long Integer, press gold key button
Description Text, 50
Set the description field to be indexed no duplicates. Save the table, open
it in datasheet view, and type in a l ist of your customer groups, such as
"Foundation Group", "Special Committee", etc.
Then make a Customer table like this:
CustomerKey AutoNumber, Long Integer, press gold key button
CustomerGroupKey Long Integer
Name Text, 50
Address Text, 50
Phone Text, 15 or 20
Email Text, 75
The CustomerGroupKey field should be indexed allowing duplicates.
<somebody help me out here> There is a way to set the CustomerGroupKey
column so you can get nested datasheets, and also to get the
Customer.CustomerGroupKey field to show the related descriptions, but I
can't remember.
Save the table and close it. Then goto the relationships window using the
toolbar button. Add your two tables to the relationship window, and drag
the CustomerGroupKey from the CustomerGroup table and drop it on the
CustomerGroupKey in the Customer table.
Save your changes.
After entering some customer records, you can make a select query and put
one of your customer groups in the criteria of the grid.
--
Peace & happy computing,
Mike Labosh, MCSD
"It's 4:30 am. Do you know where your stack pointer is?"
