how to set relationships when 4 tables are interlinked

  • Thread starter Tracey Stepping Stones
  • Start date
T

Tracey Stepping Stones

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
 
A

Amy Blankenship

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
 

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

Similar Threads

Study Database Relationships 9
mail merge with one to many issue 1
Transpose data in a report-Field values broken down to separate co 9
How can I use relationships to auto-create records in my subform? 1
Many-to-many-to-many 3
INSERT records within a SELECTED set 1
Working with many-to-many relationships in Access 2007 8
How to design a Sponsor Table, when a sponsor can be of many types 1

Top