You need to sign in to do that
Don't have an account?
Stefan
Look up field unique?
I have a lookup field on Account whcih looks up a custom object.
I would like this field to be unique on the account record. Is there any way using validation that I can enforce this.
Hi Stedan,
You could try the following workaround :
- Create a text field myFIELD on the account and define it as Unique
- Create a workflow rule that update myFIELD to store the id set in the lookup
This way it would be as if you had set the lookup field as unique.
Tell us if it works...
If you had a master detail relation ship, you could have taken a Roll Up Summary field solution.
All Answers
Hi Stedan,
You could try the following workaround :
- Create a text field myFIELD on the account and define it as Unique
- Create a workflow rule that update myFIELD to store the id set in the lookup
This way it would be as if you had set the lookup field as unique.
Tell us if it works...
If you had a master detail relation ship, you could have taken a Roll Up Summary field solution.