niko

Thank you all so much for your help. Fenton and EOS, I have been doing some reading on the A/B method, and I understand what you're saying now.

Thank you all for your help! Fenton, this database is still in relationship development and not in active use, so I don't have to worry about timing too much. I'm going to do the reading you guys have given me, and I'll be sure to get back to you if I have any questions.

Lee, All I get when following that link is the FM Non-profit store page. - Niko

Here goes my first FM Forums post. Please bear with me. I am working for an organization that is probably not very unique in its needs, but I am a bit of a meticulous perfectionist, and I can't find the absolute best way to scheme this relationship. Our organization has families, individuals and students who participate in programs. Some programs are free and others cost money. Our programs are occasionally co-sponsored by outside organizations. Additionally, we're a non-profit that accepts donations and grants from organizations, parishes, and individual/family donors. We want to track information about our program participants. Specifically, we want to track the organizations and parishes that they're involved in. My initial structure went a little like this: people--<registrations>--programs people--<peopledonations>--donations people--<peopleorganizations>--organizations people--<peopleparishes>--parishes In this case, everything runs through people. However, if an organzation makes a donation directly to us, we have no way to mark this without running it through a person. I've attached the relationship diagram for our database so you can see what I mean. Is there a better way to be doing this? Is there a way I can draw a secondary relationship to the donors table directly from the organizations or parish tables? Thanks for your help! - Niko ovm_database.pdf