Monday, February 27, 2017

How to Create Foregin Key Relation In AX 2012

Table Relation:

Foreginkey Relation  For Example

  1. First create a new table like Foreginkey table and add a new fields as u want 
  2. And create new ETD as ID and drag into Foreginkey table
  3. Then create  new index for table in the name of ID
  4. In Index property set alternate key "YES" and allow duplicates "NO" 
  5. Then In Foreginkey table property set primary key as Index name "ID" in lookup
  6. And then  ETD "ID" property set  ---> reference table ---> as Foreginkey Table
  7. Then expand the ETD "ID" right click ----> table reference ---> new table reference and related field as "ID"

  8. At last if u  drag an ETD to any other table it will appear like this 
  9. This is foregin key relation.

No comments:

Post a Comment