You might have noticed when you drag for example the EDT CustAccount to a table it asks you if you wish to create a relation. If you answer yes a relation to CustTable and an index for the CustAccount field is created. What is required for an EDT to make that happen?
- You need to have a base table in which all valid values are stored.
- On that table you must have an index with the properties
- Allow duplicates: No
- AlternateKey: Yes
- The index must be set as Primary Index for the table.
- The EDT must have the table as Reference Table and have the field set up under Table References.
If all those requirements are met then when dragging that EDT to a table AX can create a relation and index for you.