Jump to content
Sign in to follow this  

Payments to Facility or Site

Recommended Posts

I think this is going to be impossible to describe in enough detail for anyone the help but I'll try.

I'm developing a CRM that tracks Sites, Contacts, Agreements and Payments. Sites and Contacts a Many to Many so there is a join table included. To further add to the my troubles there is a link to a participant collection database (we can just call it participants). As we collect participants we track what Site the Participant came from and now the Contact provided that participant to us. (until recently only the site mattered not the contact).

The trouble I'm having is coming up with a way to record and track payments for Site and/or Contacts. We used to only have to pay a Site so it was easy. Now we have to pay either the site or the contact based on the Agreement that they have signed.

All participants have a site, all sites have contacts but I only want the participant to show up in one list to be paid. If the agreement is to pay the site they need to be on that list if it is to pay the contact they need to be on that list.

Does any of that make sense? If you have any suggestion on table structure please let me know.

Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  


Important Information

By using this site, you agree to our Terms of Use.