how to set relationships when 4 tables are interlinked

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

We are a charity with 4 tables - Friends, Sponsors, Gift Aids and Gift aid
claims. I have been able to link Friends to Sponsors but would like to link
those who gift aid - to the sponsor form and also the date of that sponsors
claim. But Access will not allow me to do it. It is not really a many to
many how do I do it?

My primary keys are - Friend ID, SPonsor ID, Gift Aid IS and Date. I want to
link
Friend ID - SPonsor ID
Sponsor ID - to Gift Aid ID
Sponsor ID to Date and
Gift aid ID to Date
 
Sounds like you need a data redesign. If friends can be sponsors and also
somehow relate to gift Aid (not sure what a gift aid might be), then you
should have just one record that identifies the WHO, then related it to
multiple records that describe the WHAT. If you post back with more details
of what's actually going on here, someone might be able to come up with
something better than:

People
======
PersonID
FirstName
LastName
etc.

Donations
========
DonationID
PersonID
DonationTypeID
DonationDate

DonationType
=========
DonationTypeID
DonationDescription
DonationAmount

Not sure what claims are doing, so I'll leave that to keener brains.

HTH;

Amy
 
Back
Top