I'll assume for now that one Organization can have many Representatives and many Donors.
The Organization table should have an auto-enter serial key, OrganizationID.
Both the Representative and Donor tables should have a numeric, foreign key OrganziationID.
Your relationships should be drawn from Organization::: OrganizationID to Representative:: OrganizationID and from Organization:: OrganizationID to Donor:: OrganizationID
After you have this part working, you should ask yourself if the representatives can work for more than one Organization. Similarly, can a donor give to more than one Organization? If your answer is yes to either or both of these questions, then you might have to use "join" tables to handle the many-to-many relationships.
This is very helpful information, Jade. Thank you for your help, I will create this organizationID field and have it automatically entered as a serial. With the donorID and representativeID I already have them as automatically generated numbers, is this correct? I will look into the join tables as per your advice. :)
Avi Davis wrote:
… With the donorID and representativeID I already have them as automatically generated numbers, is this correct?
Yes; donorID should be in the Donor table and representativeID in the Representative table. You will need these id's later when you implement the join table(s). (For now, I would recommend that you get it working without the join tables.)
I think your initial problem was that you had the relationships backwards (i.e. you were linking one representative to many organizations rather than the other way round).