Blog

Microsoft Dynamics AX Blog

9
Posted May 31, 2010 in Blog by Amer

How to Create a Primary Key for a Dynamics AX Table

This topic might not be new to most of you guys, but I always wondered how can I create a primary key to a Dynamics AX table?

You could easily create index in any table in Dynamics AX and you could specify that this index is “not duplicated”, which means that values of the field(s) should be unique among the table values. But this does not mean that you this index is a Primary Key index!

To create a Primary key you have to set the PrimaryIndex property in the list of that table properties.

PrimaryIndex Property

When you choose the PrimaryIndex property you have to set that index as “not duplicated”. Once you do that, you will have the icon of that index changed to be like this:

Primary Key Index Icon

Dynamics AX 2012 Event

Recent Posts

Tags

.NET .NET Business Connector AIF Amer Arabic Architecture Book CLR Interop Community Database Development Dynamics AX Dynamics AX 6.0 Dynamics AX 2009 Dynamics AX 2009 SP1 Dynamics AX 2011 Dynamics AX 2012 Dynamics AX Brains Enterprise Portal Error Event GDC Hijri IIS Implementation Integration Kerberos Ledger Journal Materials Microsoft stack MorphX MSDynamicsWorld.com ODC Files Presentation Sales Order Web Service Saudi Arabia SureStep Training VISUAL STUDIO.NET WF Workflow Workflow Approval Workflow Task X++ X++ Editor

Archives

Random Testimonial

  • ~ Mohamad Adel, Sr. Dynamics AX Developer at Al-Fanar IT

    Adel"I recommend Amer Atiyah as i worked with him in many simple and complicated tasks and i realized that he is very intelligent in the way of thinking to solve tasks problems. He has a very good experience and knowledge of his job. He is very hard worker, committed, organized and creative and very open mind in his work and that is the reason if his brilliant in his specialized field. He is always showing a high degree of professionalism and ability to deliver and accomplish very complicated tasks at any condition with high quality. I am recommending him to work in any team and i know he will fit with all challenges. Purely, he is a professional guy. I wish to him more and more success in his career and his life."

  • Read more testimonials »