Hello,
I am working on a database for work and I'm not sure how to fix it. I have intermediate skills so this may not be that hard.
For my database the business has Clients who they conduct Needs Assessments for, but they only conduct 3 needs assessments.
I have a Needs Assessment table with Client ID as the foreign key. Does anyone know how I can limit the number of times a Client ID shows up in the foreign key field to three? Any help would be greatly appreciated. Thank you.