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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

  • Create New...

Important Information

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