hi everyone, is there some way to create and assign Composite Primary key for a table in Dynamics AX 2012?? If yes how?
As i have a table (my own customized), it have 2 fields both are of string type. so i want to use these fields as composite primary key. how this could be done as ax 2012 is restricting to this
*This post is locked for comments
I agree with Martin, try to keep RecId are your PK and make your composite key the replacement key. If you really need the composite key as the primary, you have to set the "allow duplicates" to "no" and the "alternatekey" to "yes" on the index. If you then save the table, then the index will be available for selection in the primaryindex property.
If you want to follow "AX2012 way of doing", you should use SurrogateKey as PK and your composite key as a replacement key.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (