K
Kelly
I have made the following tables.
TableDonors
DonorIdentificationNumber (Primary Key)
DonorFirstName
DonorLastNAme
DonorAddress1
DonorAddress2
DonorCity
DonorState
DonorZIP
DonorHomePhone
DonorWorkPhone
TableFunds
FundNumber (Primary Key)
Fund Name
TableDonationMain
DonationNumber (Primary Key)
Date
Method (cash, check, etc.)
DonorID (foreign key to TableDonors)
TableDonationDetails
DonationNo (Foreign Key to TableDonationMain)
Amount
FundNumber (Foreign Key to TableFunds)
When I click on Donors, it expands to Donation Main, Donation Main expands
to Donation Details, but I can't seem to link Funds to anything.
Here is some background. I am trying to make a database where I can post
donations made to 4 different funds. A donor however may donate to 2 or
three funds, using the same check. I then have to turn around and make a
reciept for their check both monthly and annually. The above has been given
to me as a suggestion a couple of months ago, but I have not had time to be
working on this. I am trying today to make one form with all four tables,
but my donation main table just won't link to both tables that I am trying.
Any suggestions?
TableDonors
DonorIdentificationNumber (Primary Key)
DonorFirstName
DonorLastNAme
DonorAddress1
DonorAddress2
DonorCity
DonorState
DonorZIP
DonorHomePhone
DonorWorkPhone
TableFunds
FundNumber (Primary Key)
Fund Name
TableDonationMain
DonationNumber (Primary Key)
Date
Method (cash, check, etc.)
DonorID (foreign key to TableDonors)
TableDonationDetails
DonationNo (Foreign Key to TableDonationMain)
Amount
FundNumber (Foreign Key to TableFunds)
When I click on Donors, it expands to Donation Main, Donation Main expands
to Donation Details, but I can't seem to link Funds to anything.
Here is some background. I am trying to make a database where I can post
donations made to 4 different funds. A donor however may donate to 2 or
three funds, using the same check. I then have to turn around and make a
reciept for their check both monthly and annually. The above has been given
to me as a suggestion a couple of months ago, but I have not had time to be
working on this. I am trying today to make one form with all four tables,
but my donation main table just won't link to both tables that I am trying.
Any suggestions?