Linked table ?

[cheyenne2002]

I am trying to create a donations database. I would like to link my existing member table and non-member table to this database, because I will be contacting members and non-members to donate to this years annual drive.

My question: If I create a field in both of these linked tables that when checked off will create a new table of donors (by using a make table query) can I add to the donor table periodically during the year as I add checkmarks? Will it duplicate any that already have checkmarks and were added previously?

Also, next year if I remove the check marks from the member table in the original membership database will it remove them from the donor table in the donations database when I start to add things for next year.

My point is that I'm trying not to have to type in all the information on my members/non-members because it is such a hassle when someone changes an address or phone number to remember to change all the various databases I have. I would love to have just two databases, one with members and one without members that I can pull from (via linking) in the Donations database. I do not want to put non-members and members in the same database as it is linked to our website lisitng members (so that is out of the question, per the boss)

Thanks for any insight you can offer.
Sharon

 

[dhookom]

There should be no reason to have tables for both members and non-members since you should be able to use a field to filter based on membership.

You didn't mention anything about primary key fields. This would be absolutely critical to any solution. I would just link to the table of people and use the records within your new database.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]