0

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?

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
Raas
  • 261
  • 8
  • 25

1 Answers1

1

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.

Jan B. Kjeldsen
  • 17,817
  • 5
  • 32
  • 50
  • But my Index has TwoFields. So i dont know how can i get that in lookup of primaryIndex of table? – Raas Mar 18 '15 at 17:24
  • You can, but only if you use an old style table. This property is only exposed in the XPO. It is not meant to be used for new tables! – Jan B. Kjeldsen Mar 18 '15 at 22:04