Breaking news from around the world
Get the Bing + MSN extension
Now Available in Community - MBAS 2019 Presentation Videos
Catch the most popular sessions on demand and learn how Dynamics 365, Power BI, Power Apps, Power Automate, and Excel are powering major transformations around the globe. | View Gallery
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I am new in AX7. I want to know how can we find relations between two tables which can be used for creating a Query.
In AOT you can find Relations node in the table definiiton. It's defined from child to parent, for example from SalesLine to SalesTable.
However, I need a relation between PurchLine and LogisticsPostalAddress. How can I set that?
I need to display Address in front-end.
That works exactly the same way!
Go to PurchLine -> Relations and you will find a relation named DeliveryPostalAddress.
How can I use it? I can only see,
What should I use after PurchLine and LogisticsPostalAddress?
Can you please help me here.
Right click PurchLine table - Open in designer. Now you can see the properties of the relation, and all the fields that are part of the relation.
I really don't have any idea on this. There are no specific relation properties which are similar in both tables.
You can see the relation between these two tables is PurchLine.DeliveryPostAddress==LogisticsAddress.RecId.
You can customize the relation between two tables by setting the properties of the relation.
The relation is not defined in both tables, only in the child table, like I already mentioned.
Are you now able to find the information?
I need a relation between these two tables. I am creating a Report and Output has to be Address of data that I have selected in PO.
New in AX7. Please assist me here. What can be done if I only need address of selected PO.
Are you sure it was not already explained to you?We have shared you a general process how you can find table relations in AOT. In addition to that, the exact relation between PurchLine and LogisticsPostalAddress was shared to you.
Could you please read through all messages once again, and see if you find the information in there.
Also, if your issue is resolved, could you please mark all helpful answer(s) as verified. Thanks!
Hi Ashish ,
Nikolaos already gave you directions about how to find relations , so i am not going to talk about same .
I see you are trying to set relation in your query . If you know the relation exist between datasources you added in your query then you can use use relations property = yes on the LogisticsPostalAddress datasource of your query and dont have to create anything manually , which i see you are trying to do.
Just right click and see properties of LogisticsPostalAddress1 datasource in your query and set the property top yes
If you are looking for relation between PurchLine and LogisticsPostalAddress then see it in this pics. You can also see it in AOT on PurchLine table in Relations node. In your example screenshot, Select DeliveryPostalAddress in Field and RecId in RelatedField property
Thanks Khushhal. I got it. But I need to display telephone no., URL and facebook along with this. I guess it will take many other relations. Can you give me an idea about that?
Your answer solved a lot for me. I am trying to add these things as well along with address. Also, I am using filters(Dynamic Parameters) to see address/phone no. only of highlighted entities. I guess it will take a lot of relations in this case. Can you please assist me on this.
Look at relation LogisticsPostalAddressBaseEntity on PurchLine. It has relation with entity LogisticsPostalAddressBaseEntity, then you can link LogisticsPostalAddressBaseEntity with LogisticsElectronicAddress on LogisticsPostalAddressBaseEntity.LocationRecId = LogisticsElectronicAddress.Location. Then you can display Tel no., URL, facebook from LogisticsElectronicAddress table
You could also consider using a temp tables as your report data sources. That makes it easier to separate (complex) data retrieval from the report design work. And then you can use x++ code (in addition to queries) to retrieve data.
I suggest you check the standard purchase related reports for some inspiration.
You can look at reports such as PurchPurchaseOrder and VendInvoice. The standard system is often the best documentation of x++ and D365 development. So you should use it as a reference, documentation and inspiration.
Why can't you use x++? Handling these complex datasets such as contact information can be quite difficult to fine tune without using x++.
Business Applications communities