Unique value field

I want to make a job designation unique.  In other words, I want each job designation assigned to only one employee.  I have two ideas how to get around this, but not sure if they are implementable:

Option 1: Use the designation field but create a script that will check for duplication in the entire employee database as part of validation. Can this be done? If so, any hints?

Option 2: Create a custom field of type Select that contains the designations that are available. But can this field be configured so that it is only used once in the entire employee database? 

Any tips to point to the right direction will be appreciated.



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.

Laurence - this can be done by setting a unique constraint in the database. If you can add a support ticket we will add it for you.

On Friday, November 15, 2013 2:33:18 PM UTC+5:30, lxnow wrote:
I want to make a job designation unique.  In other words, I want each job designation assigned to only one employee.  I have two ideas how to get around this, but not sure if they are implementable:

Option 1: Use the designation field but create a script that will check for duplication in the entire employee database as part of validation. Can this be done? If so, any hints?

Option 2: Create a custom field of type Select that contains the designations that are available. But can this field be configured so that it is only used once in the entire employee database? 

Any tips to point to the right direction will be appreciated.



You received this message because you are subscribed to the Google Groups "ERPNext User's Forum" group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un...@googlegroups.com.

For more options, visit https://groups.google.com/groups/opt_out.