How to: Create a Relation

Use this step procedure to create a relation between the AJ_SubGenreTable and the AJ_BookTypeTable. The Sub-genre is related to the BookType table.

For example, the Sub-Genre 'Poems' can be only related to the record "Poetry" in the AJ_BookTypeTable table. You should not be able to have a "Novels" as Sub-genre for "Poetry".
To understand the example scenario - Gohere
To understand more details about types of relations: Gohere.
1. In the AOT, locate the AJ_EDTBookTypeID EDT.
2. Right-click the AJ_EDTBookTypeID EDT and select Properties.
3. In the ReferenceTable property enter AJ_BookTypeTable.
4. Close the properties sheet.
5. Expand the AJ_EDTBookTypeID node.
6. Right-click the Table References node and select New > Table Reference. A new table reference is created.
7. Right-click the AJ_BookTypeTable Table Reference and select properties.
8. In the related field property, enter AJ_BookTypeID
9. Close the property sheet and save your changes to the EDT.
10. If the database synchronization dialog appears, click Yes.
11. Drag the AJ_EDTBookTypeID EDT to the field node on the AJ_SubGenreTable
12. When prompted to add the ForeignKey relation from the EDT, click Yes. This will automatically create the relation between the AJ_SubGenreTable and the AJ_BookTypeTable.
13. Rename the AJ_EDTBookTypeID field to AJ_BookTypeID.



 
 
 
 
 
 
 
 
 
 
 
Note: Relations can also be added manually by right-clicking the relations node on the table.
However when you create the reference on the EDT and set it as a primary key, once the EDT is added to a table, the system will prompt to add the reference automatically.

Comments

Post a Comment

Popular posts from this blog

Change Tracking in Data Entities and latest changes

Image
If you’ve ever worked on data integrations or migrations in Dynamics 365 Finance & Operations (F&O), you know the pain of moving large datasets repeatedly. Enter Change Tracking - a feature that feels small but makes a huge difference. What is Change Tracking? Change Tracking lets you detect and export only what changed since the last sync, instead of dumping the entire dataset every time. This is used by Microsoft already in the out-of-the-box frameworks : Inbuild Integrations with Microsoft CRM or BI scenario. Could be used for integration towards external apps. Incremental data migration  using DMF during cutovers. BYOD exports where performance matters. Why It Exists Without Change Tracking: Every export = full dataset. More time, more cost, more risk of throttling.  Most costs (per transfer / transaction). With Change Tracking: Only inserts, updates, and (sometimes) deletes are exported. Faster, lighter, and easier to schedule. Lesser costs. Types of Change Tr...
Read more

Finding Table Names and Data Entities in D365 F&O

Image
When working with data in Dynamics 365 Finance & Operations , one of the most useful skills is knowing where your data lives - which table or data entity holds the field you’re looking at. Why? Because this knowledge unlocks so many possibilities: Extracting data for analysis. Mass updates through Data Management . Building integrations or troubleshooting issues. Think of it as peeking behind the curtain to understand the architecture that powers your forms. Why This Matters Here’s a little reality check: Different fields on the same form can belong to different tables . A single field can appear in multiple data entities . And not all users have equal access - System Admins have the most visibility (SysTableBrowser, entity lists, etc.). So, if you’ve ever wondered “Where does this field actually come from?” , the below could guide you. Part 1: How to Find the Table Name for a Form Field Open the Form Navigate to the form where the field lives. Say, CustTableListPage. Right-C...
Read more

D365Ops Tip #1: Table browser

Image
It has been few months that the new AX, Dynamics 365 for Operations is released to market. And being a web client, the Business users and/or Application consultants working with AX, don't have the privilege of going into the AOT from the Client even with 'System Administrator' role in AX . And one of the most used tool used by any Developer and also sometimes by App. consultants is the Table browser accessing which is a bit different with the New AX - this post illustrates on how to achieve this with a Change in URL. We can start with an example, please observe the URL in the browser when you try to open the Users form (System Administration > Users > Users). https:// d365ops0516devaos.cloudax.dynamics.com / ?cmp=USRT&mi=SysUserInfoPage so now, from here if you want to open Table browser for "Users form", you can do so without using any tools by just changing the URL. https://d365ops0516devaos.cloudax.dynamics.com/?cmp=USRT& mi=SysTableBrow...
Read more