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