Validate Unique Form

Validate Unique Form

I have a form which (Ppl-Sponsors - in the ERD below) and I need to validate it so that it is a unique entry.
Not allowed:
  • Same Person & Same Company & Different Sponsorship
  • Same Person & Different Company & Same Sponsorship
  • Same Person & Same Company & Same Sponsorship
  • Same Person & More than 3 different sponsorships
  • Same Person with no Main Sponsor
Any thoughts?

Thanks in advance

Pete