Linking Tables

[MaineLady]

I am tracking donation data for a non-profit group. I have created a database with the data they provided for the 2013/2014 Fiscal Year. I now want to set up a table that will use the Name/Address/Phone info from the first table and have "new" blank fields to fill in the donation info for the new Fiscal Year. How do I do that?

[ranman256]

You need a new table say: tDonations
and tClients.
tClients has the name, address, etc AND a clientID (usu an autonumber)

tDonations table:
[clientID] (long integer)
[Amt] (currency)
[DateOfDonation] (date)


the tClients.clientID will link to tDonations.clientID (as a 1 to many relationship) 1 client can make many donations.

use the table wizard , and it will guide you on adding fields.