Notifications
Announcements
No record found.
Can anyone explain about Primary key based and Single fields alternate key based Foreign key relation in AX 2012 and also its implementation.
Thanks,
Prateeksha
*This post is locked for comments
Hi Prateeksa,
I don't understand your aim on this question, but have a look at the next MSDN page: msdn.microsoft.com/.../hh812105.aspx. IIt might help you.
Good day Prateeksha,
I have recently learned about Surrogate key, Surrogate Foreing key, Surrogate key replacement fields and Alternate key. Microsoft has a white paper that helped me to understand the theory behind it:
www.microsoft.com/.../details.aspx
If you are looking for a simple example I can share it with you, just let me knot it if want.
Like Andre said, it'd be nice if you can elaborate on your question.
On the other hand, it's MS SQL database engine behind AX2012; May be you can look at a synchronized AX DB in SSMS and see what is being created in SQL?
Regards,
Dominic
Hello All
Thanks for the answers.
I need a simple example on Foreign Key relation. How do we set Primary Key based foreign key relation and Single alternate key based foreign key relation?
Hi,
I was able to create both type of Foreign Key relation following the instructiosn here.
msdn.microsoft.com/.../aa556809.aspx
Note:
- Primary key is the unique index specified in the Parent table PrimaryIndex property. It can consists of 1 or more fields
- Alternate key is an unique index specified in the Parent table, with its AlternateKey property set to Yes. However, to be eligible for use for creating foreign key relation, The alternate key can only consist of a single field.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
