How to do a combination of two fields and define this combination as unique

[Former Member]

Hi

Book about MDM has text

"A customer number can be assigned only once and should therefore be defined as a unique field. For the banking information, on the other hand, the combination of account number and bank number must be unique, and not just the individual fields themselves. In this case, the combination of the two fields would be defined as unique."

How to do it?

[Former Member · Accepted solution]

HI Konstatin,

Please refer to this thread for answer to your query:

Thanks,

Ravi

[Former Member · Accepted solution]

Hi Ravi,

Thanks!

[former_member198938 · Accepted solution]

Create your table , with the fields to be marked as unique.

Now click on the repository name, you will get all the tables listed in the right pane.

Click on your table and in the below pane you will find the unique fields option.

Open that and select simultaneously ( with ctrl key), the fields to be made unique and right click and make the combination as unique.

Hope this answers your question.

Award points if helpful.

Thanks,

Ranjeet Singh