Find relationships between D365 FO tables

(3) Share

Report

Posted on by D365FO Junior-Dev

441

Dears,

I am looking for away or tools to find relationsships between D365 FO tables as I am a begginer it is a bit difficault for me to identify exact relationships in SQL Server and AOT.
Thanks,

Categories:

Dynamics 365 Finance

Microsoft Dynamics AX

I have the same question (0)

All responses (4)

Answers (1)

Martin Dráb 237,965 Most Valuable Professional on at

Like (1)

Report

Are you aware of the Relations node on F&O tables?

Using SQL for that isn't a good idea, because F&O doesn't store this information in a database.

Was this reply helpful? Yes No
Verified answer

Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (2)

Report

Hi,

From AOT, open any table relations to know all its relations.

You can read more about relationships in the following blog:

https://www.d365snippets.com/2021/12/table-relations-in-d365-with-examples.html

Thanks,

Waed Ayyad

If this helped, please mark it as "Verified" for others facing the same issue

Was this reply helpful? Yes No
Waed Ayyad 9,039 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

Is your issue resolved? If yes, mark the answers that helped you as verified.

Thanks,

Waed Ayyad

Was this reply helpful? Yes No
Suggested answer

Vishal Tiwari 393 on at

Like (1)

Report

The Relation node under the Table will help retrieve that information. Since you mentioned you're a beginner, you can easily understand relationships through various videos. Here’s one for AX 2012:

https://www.youtube.com/watch?v=nWyG5HFy1VE

Was this reply helpful? Yes No