Hi all, sorry for the ambiguous and possibly incorrect thread title but I had no idea how to briefly describe my challenge.
Currently I have a database with the following relationships:
One Client has multiple Entities
One Entity has multiple EntityServices
One Service has multiple EntityServices (basically a table of service lines)
Now this is all working fine, but I want to create a table by the name of EngagementLetters. It should have the following relationships:
One Client has multiple EngagementLetters
One EngagementLetters has multiple EntityServices
and the tricky one: all EntityServices under a single EngagementLetter must have the same Client
I've been able to create the above, but not the last point. It's stumped me, I have no idea how to do it! Would anyone be able to help with this?
Thanks in advance!
Cheers,
Andrew