how can i add a payment log to non profit contribution template?

  • Thread starter Thread starter hady
  • Start date Start date
H

hady

i am using template that i donlowded for non profit contribution using
access, the template does not have log to keep track of payyments, could
anyone please tell me how to do that, i am an new user for access, thank you
 
If by "contribution" you mean donation, the template has a donations table
showing who the donor is, the date of the donation and the amount of the
donation. This table should have a DonationID for the prinary key. To add a
payment table, go to the database window and add a new table named
TblPayment. Make the first field PaymentID and set it as the primary key.
Make the second field DonationID and join it to DonationID in the donation
table. Complete the table by adding the following fields: PaymentDate,
PaymentAmount.
 
Back
Top