Inputing Checks

[bornstein.a]

I am in the process of creating a database for a small non-profit organization to track all of the donors' contact and donation information. I'm very green to Access so bare with me... When entering a donation under payment types there are a number of options listed (check, credit card, cash, in-kind) but I can't figure out how to enter a check number - which is important for being able to back and check specific donations. I also am trying to figure out how to specify if donations are restricted or unrestricted. It seems like both of these things would be as simple as adding another field, but I'm not sure if that's right/how to do that. Any help would be greatly appreciated!

[RayMilhon]

Your donation table should include the following fields

donationID Autonumber PrimaryKey
donorID Number Foreignkey to donor table
DonationType String
DonationAmt Currency
checknumber number
account String account number the check is written from
Bank String routing number for the bank check is written on
Restricted yes/no If No then its unrestricted

When building the form for Donation Data Entry
You would use a combo box to select the donor
A combo box to select the donation Type (check, credit card, cash...)
the Account number would be used in either check or credit card donations
the routing number and check number would only be used for check donations.
A check box or Radio button would be used for the Restricted field.