Showing posts with label Table Relations. Show all posts
Showing posts with label Table Relations. Show all posts

How To: Create Related Field Fixed Relation In Ax 2012

Hi Friends,
Creating Relations in Ax 2012 is not that much difficult, today ll see how to do it in "3 Simple and Easy Steps" . Lets Start
Note: An Xpo for this example is provided at the end.


Step 1:




  • Create a BaseEnum  as AccTypeId , with elements as below 
  •             > Customer  - 0
                > Vendor      - 1




    • Create a EDT as AccTypeEDT and in the propertie's you will find a property as EnumType:   Set it to : AccTypeID(Our BaseEnum)



    Let say you have 3 tables as following:
    1. AccTypeTable.
    2. CustomerDetails.
    3. VendorDetails.

    Step 2:
    • Now create  table  AccTypeTable with fields AccountNum(String), AccType(Enum), DepartmentBelongs(String).
    • Note: When Creating AccType Field create a enumType field and in the properties find ExtendedDataType and fill that with our AccTypeEDT witch we created in step 1.