Primary Key as combination of two fields

(0) Share

Report

Posted on by Gautam

3,945

Hi All,

we have a customized table containing two fields , one is of string type and second is int64.
In first field user is going to enter value and second field we are storing the recId of one related Table.
Our requirement is that , combination of both field value should not repeat.

Kindly suggest, how to achieve this

Thanks

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

Create a unique index with these two fields. It doesn't mean that it must be a primary key - in fact, you should normally use the surrogate key as the primary key, but you can have any number of additional unique indexes.

Was this reply helpful? Yes No
Gautam 3,945 on at

Like (0)

Report

Hi Martin, I have created a index with these two fields and "Allow Duplicate" - "No" i have given , but its throwing error even when one field value is similar to any record , its not checking the both field value.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,801 Most Valuable Professional on at

Like (0)

Report

I don't believe that you've just found a critical bug in AX that nobody else have run into, therefore I assume that you're not testing it right. Please review your data in table browser; you probably have a conflict with records that you're not aware of.

If you don't find anything, show us your specific implementation, data you're using and the exact error message.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi martin,

i m facing the same problem

i have created index with 2 fields (enum and string)

where i set allow duplicates no and alternate key yes

enum values 0- pay 1- receive

when i insert data "pay id1"

and m inserting data "receive id1" its throwing error that data already exists.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

hi martin ,

i got the answer

Was this reply helpful? Yes No
athombare 135 on at

Like (0)

Report

@kasthu

what was the issue because I'm facing the same issue

Was this reply helpful? Yes No
sivakarthk 10 on at

Like (0)

Report

Hi,

Any heads up on this?

Thanks in advance.

Regards,

Siva

Was this reply helpful? Yes No