How to find relation in tables?

(0) Share

Report

Posted on by Ashish020996

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.

I have the same question (0)

All responses (22)

Answers (3)

Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

In AOT you can find Relations node in the table definiiton. It's defined from child to parent, for example from SalesLine to SalesTable.

Was this reply helpful? Yes No
Ashish020996 25 on at

Like (0)

Report

Thanks Nikolaos,

However, I need a relation between PurchLine and LogisticsPostalAddress. How can I set that?

I need to display Address in front-end.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

That works exactly the same way!

Go to PurchLine -> Relations and you will find a relation named DeliveryPostalAddress.

Was this reply helpful? Yes No
Ashish020996 25 on at

Like (0)

Report

How can I use it? I can only see,

PurchLine.=LogisticsPostalAddress.

What should I use after PurchLine and LogisticsPostalAddress?

Can you please help me here.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ashish020996 25 on at

Like (0)

Report

I really don't have any idea on this. There are no specific relation properties which are similar in both tables.

Was this reply helpful? Yes No
Verified answer

WillWU 22,361 on at

Like (1)

Report

Hi Ashish,

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.

Best regards,

Will

Was this reply helpful? Yes No
nmaenpaa 101,160 Moderator on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Ashish020996 25 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

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!

Was this reply helpful? Yes No