primary-keyaxaptadynamics-ax-2012surrogate-keydynamics-ax-2012-r3

Adding Existing Index in a table (which is made of two fields) as Primary Index? ax 2012

I have an index TestIndex in my table with two fields: Code1 and Code2.
Index Properties: Allow Duplicates:No, AlternateKey: Yes
Field Properties: Mandatory:Yes AllowEdit:No

When I got to Table Properties PrimaryIndex:SurrogateKey. I want to change this PrimaryIndex to TestIndex. But when I click on DropDown it's not showing TestIndex value. When I enter manually TestIndex and click enter its showing TestIndex. But when I click on the dropdown I am not able to see testIndex.

Why? The manual thing which I have done is wrong or correct?

How can I get TestIndex in dropdown of primaryIndex?

Solution

  • See Table Keys: Surrogate, Alternate, Replacement, Primary, and Foreign

    A table can have several alternate keys. Any one alternate key can switch to being the primary key, if the alternate key is comprised of only one field.