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

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
 
S

Steve

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top