microsoft dynamics - Add a Relation foreign key in AX2012 -

microsoft dynamics - Add a Relation foreign key in AX2012 -

i have create 2 new tables: employertypetable , listdoctable

------------------- ------------------ -employertypetable- - listdoctable - ------------------_1______________________________*__------------------ - - - - - - - - ------------------- ------------------

an object of employertypetable can have many objects of listdoctable (one many)

how can implement in ax2012?

how to: create tables

how to: add together relation table

the initial steps adding relation same regardless of relation type adding. later steps diverge based on relation type. remember save changes in aot.

in aot, move info dictionary > tables, , expand table relation added to. right-click relations node, , select new relation. right-click newly added relation, , select properties. set name of new relationship modifying name property. in table property, select related table. use validate property determine whether relation should used validate info when info entered forms. right-click new relation, select new, , click 1 of following: normal specify relation fields without conditions. field fixed specify relation fields restrict records in primary table. related field fixed specify relation fields restrict records in related table. foreignkey specify correspondence between foreign key field in nowadays table primary key field in parent table. proceed subsection corresponds relation type selected in before step.

microsoft-dynamics x++ ax morph-x