avoid duplication in location table

[divya123]

in location table whenever adding location filed value manually if that   location is already existed then it show message that already existed that location &   show invalid insert , this is what show if location is already existed in location table(cmn_location).

kindly help me with your suggestion how can i write business rule for that.

Thanks

Divya

[Alikutty A · Accepted solution]

This is the location form and not the right place. Please follow these steps

1) You should right click the Name field and configure dictionary

2) Then on the form that loads, Again configure form layout from the header and add unique field on this form.

3)

4) Add the unique field on dictionary form and check it as true and Save.

Once you do so, the system wont allow a user to enter multiple locations with same name.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response

[divya123]

thank you Alikutty for your support, business rule is working but i just want to avoid using that business rule

will do unique check box on filed dictionary.

[divya123]

if already duplicates are there then this unique check box is not working even if i select then save it is not accepting.

[Alikutty A]

Business rule is an overhead but it can be used if you need a custom error message to be displayed ie If many users are interacting on the UI and keep it more user friendly.

You will have to fix your duplicate records before applying the unique key. Those are not existing records and need to be fixed.

Thanks

Please Hit like, Helpful or Correct depending on the impact of the response