Personalized Community is here!
Quickly customize your community to find the content you seek.
Have questions on moving to the cloud? Visit the Dynamics 365 Migration Community today! Microsoft’s extensive network of Dynamics AX and Dynamics CRM experts can help.
2023 Release Wave 1Check out the latest updates and new features of Dynamics 365 released from April 2023 through September 2023
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Community | FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Upcoming TechTalks | All TechTalks
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
If you want to follow "AX2012 way of doing", you should use SurrogateKey as PK and your composite key as a replacement key.
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.
Business Applications communities