Query Problem

[Double D]

I have a client listing that is my main list to be used for addresses
etc. This list is constantly being updated with current information.
I have a second table that is a Christmas Card listing. The
relationship is the client number. I only input client numbers
initially and then run a query to make sure that the client number is
correct. I Ieave the client name blank after inputing the number so I
can compare the two lists to be sure that the client number I added is
the proper client number. I would like to type (or cut and paste)
from the main list into the Christmas list once I have verified the
correct number. Access will not let me enter any information into the
Christmas Card name field. Is there a way around this. I should add
that the name is not always the same and I may have a client number
mutiple times in the Christmas Card list to send to mutiple people at
the same address.

 

[Jeanette Cunningham]

Hi,
A query would make this easier.
Have you used queries before?

Jeanette Cunningham

 

[Jeanette Cunningham]

Hi,
On second thoughts the easiest way would be to have just one table.
In your main table have a Yes/No field for each client.
For each client tickYes if they are to receive a christmas card and no if
not.
Now you can run a query where the ChristmasCard field is Yes.
You could paste this query into Excel if this is what you want, or use it
however you want.
This will be simpler than having 2 separate tables.

Jeanette Cunningham