Hello Buddies,
In Dynamics Ax, I want to set Primary key for particular field in User defined Table, As far as SQL concern, we could easily set Primary key. But, I couldn't set Primary key to particular field in easy way.
I hope you tat understand my question...
Thanks
*This post is locked for comments
1) Create the Table and add required fields to the table as you all knows.
2) Create an Index by dragging the required field to the Index.
3) Set the following Index properties:
a) AllowDuplicates to "no".
b) Alternate key to "yes".
4) Set the Primary Index property of the table to newly created index after creating the Index.
5) For applying auto-increment you will have to use number sequence.
Index is the correct solution for the table. You first will need to create an index with your respecitve fields that you want to be the primary index and set the index properties in the AOT to 'allow duplicates' = no. Once that is done, any indexes with that property set will show up in the PrimaryIndex drop down for the general table properties.
Hello,
Just check this out before rejecting index.
http://msdn.microsoft.com/en-us/library/bb278358(AX.10).aspx
After reading this if you think you can use index then please also set 2 more properties of your field.
Mandetory = Yes and AllowEdit = No
Thanks.
I want to set primary key for specific field in table rather using 'RecID'.. Also, Index is not given correct solution..
Thanks for ur consideration
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,280
Super User 2024 Season 2
#2
Martin Dráb
230,214
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (