Help Limiting the Number of entries a specific Client can add to a table

[matthewa]

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.

[rpeare]

Are you using bound or unbound forms?

I think it's doable with either but, for instance on an unbound form you can count the number of records before you even start and disable data entry if there are three records and only allow editing of one of the three records in the database.

The method you use depends really on how you've designed your form.

[matthewa]

Thanks for your help, I appreciate it. I just ended up putting all the records in forms so it worked out.