How to validate duplicate field values for custom MDF entries

[RishabhGupta19881]

Hello Experts,

I hope that you are doing well.
I have a requirement to restrict duplicate field value for a custom MDF.

For example: Custom MDF has field called "Short Text". Custom MDF has a unique code, but client wants to restrict unique short text also for custom MDF in current time slice i.e. same short text should not be used for any other object in current valid record.

I tried to create business key to ensure unique combination of code and short text MDF but historical record short text can be reused for another latest record of custom MDF. Kindly advise on how to achieve this.

Allowed Scenario (same short text can be reused but from historical record only-->i.e. inactive time slice)
M1
01.01.1900-01.02.2025: Short Text is "ABCDE_01"
02.02.2025-31.12.9999: Short Text is "ABCDE_02"
M2
01.01.1900-01.02.2025: Short Text is "ABCDE_02"
02.02.2025-31.12.9999: Short Text is "ABCDE_01"

Not Allowed Scenario (same short text cannot be assigned to another active record)
M1
01.01.1900-01.02.2025: Short Text is "ABCDE_01"
02.02.2025-31.12.9999: Short Text is "ABCDE_02"
M2
02.03.2025-31.12.9999: Short Text is "ABCDE_02"

[NarendraLahoti · Accepted solution]

Hi,

I am not sure of the business use case why the value pf a field across two different object need to be unique.

This can be achieved like below but will result in performance issue as the data volume for given object increases over a period of time.

Here cust_of is a the object cust_string is a field which must be unique