Share
ReportI am using:
Microsoft Visual Studio Professional 2022 Version 17.13.6
Installed products include Finance and Operations - Platform Update68 version 7.0.7606.123
Aka Microsoft D365 F&SCM 10.0.44.
Microsoft Visual Studio Professional 2022 Version 17.13.6
Installed products include Finance and Operations - Platform Update68 version 7.0.7606.123
Aka Microsoft D365 F&SCM 10.0.44.
I know that I can expand the Relations node on a table in the AOT and see what tables relate to my current table.
I'm looking for something (preferably within the Visual Studio environment) which would show me what tables use a given table in a relationship.
For example,
If I open SalesTable in the AOT and expand the Relations node, I can see the Agreement relationship
There is a relationship between SalesTable and AgreementHeader
Related Field Expression: SalesTable.MatchingAgreement == AgreementHeader.RecId
In this example, SalesTable is my current table, and AgreementHeader is the related table.
But can I see it from the opposite direction?
Say I am looking at AgreementHeader in the AOT.
I want to know all of the tables which has a relationship to AgreementHeader, essentially any relationships which have AgreementHeader as the Related Table.
I don't see anything on the table or under the Relations node which shows this.
If I right click on the table and look at the flyout menu, I don't see anything like what I'm looking for.
I tried using the D365 F&O Table relation finder
https://daxonline.org/d365/table-relation-finder.html
That still requires two tables to see the relationship path from one to the other, it won't work with just one.
I'm looking for something (preferably within the Visual Studio environment) which would show me what tables use a given table in a relationship.
For example,
If I open SalesTable in the AOT and expand the Relations node, I can see the Agreement relationship
There is a relationship between SalesTable and AgreementHeader
Related Field Expression: SalesTable.MatchingAgreement == AgreementHeader.RecId
In this example, SalesTable is my current table, and AgreementHeader is the related table.
But can I see it from the opposite direction?
Say I am looking at AgreementHeader in the AOT.
I want to know all of the tables which has a relationship to AgreementHeader, essentially any relationships which have AgreementHeader as the Related Table.
I don't see anything on the table or under the Relations node which shows this.
If I right click on the table and look at the flyout menu, I don't see anything like what I'm looking for.
I tried using the D365 F&O Table relation finder
https://daxonline.org/d365/table-relation-finder.html
That still requires two tables to see the relationship path from one to the other, it won't work with just one.
Categories:
I have the same question (0)
All responses (
Answers (
71,714
