Validation Rule?

[diofree]

Hi,
I have a table that houses employee evaluations. There can multiple reviews per employee (from manager, colleagues, etc.) but I only want ONE per person to be able to be identified as Lead Reviewer.

This is in it's own choice field, called Review Type.

How would I do this?

 

[ct2013]

Not exactly sure what you mean.
Is it working with a dropdown or combo box this field called review type?

 

[diofree]

Review type is a choice column (field) in the Reviews Table that must be filled for each review (ie. each record).

 

[ct2013]

Maybe create it as a dropdown list and then limit to who on the list you allow to add and ensure that you tick this field may not be left blank otherwise you would have defeated your point.
If you want to send a sample database i can try look at it.
(make sure to take out personal info)

 

[diofree]

Hi CT!
Thanks for your help!
Here is a quick mockup.

In the attached DB, if you look at the Reviews table, I'd like a way to make it impossible that more than one review of Johnson or Smith, in this case, can also be marked as Lead Reviewer. This is because we will weight the scores later on and put higher weight on the Lead Review.

 

[ct2013]

Hi.

Looking at your db now.
Not exactly sure what you want?

Please reply with clear instructions what youre after.

Thanks

 

[diofree]

Hey Ct,
If you look at the Reviews table.

I have two reviews of Johnson, and two reviews of Smith.
Currently, they each have one Lead Review, and one Other Review. If possible, it would be nice to enforce a way that if there is already one Lead Review of Mr. Johnson, the second review of him could not also be a Lead Review (eg. ID #2 could not be flipped to Lead Review as well).

Is this possible with validation?