Customer program list

E

EgX

hi, i'm kind of new to access. i have to make a database that, like an
address book, will have the address and phones but have a field for the
program it signed up.

And depend of the fields i put, it retrieves a list of people that fits this
list and can print it. I too need a search button to rapidly find some people.

Thanks a lot!!!
 
T

tina

do you have a specific question? this forum is not appropriate to give you
step by step instructions on how to build an entire database, if that's what
you were hoping for. if you don't know how to begin designing and
implementing your project, see http://home.att.net/~california.db/tips.html,
starting with tips #1 and #2.

hth
 
K

KARL DEWEY

Create three tables --
Contact w/ ContID, name, address, phone etc.
Program w/ ProgID & description.
ProgCont w/ ProgID &ContID.

ProgID &ContID are primary keys in their data tables and foreign key in the
ProgCont table.

Create a one-to-many relationship from Contact ContID to ProgCont ContID.
Create a one-to-many relationship from Program ProgID to ProgCont ProgID.

This allows a contact to be affiliated with multiple programs.
 
E

EgX

Well i have a database, just that if i have a customer subscribed to 1 and
another to 2 in the program A, i want to get the list of all the program A.
But the database i have only get the people that matches either 1 or 2. Can't
have a list of all A.

Context: ive a program A,B,C with 1,2,3 each program. I want to get a list
of everyone in the program A but every customer has to be in either 1,2 or 3.
 
Top