web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Relate Tables from an ...

Small and medium business | Business Central, N...

Suggested Answer

Relate Tables from an OData Web Server

(0) Share

Report

Report

Posted on by Fernando Jose R

Hello, post page 42, Sales Order, and page 22, Customer List as a web service, what I would like to know is, why do I not see any relationship between the two entities? How is that relationship generated? I can't find documentation on that.

I want to make a query more or less like the following but a relationship between customer and sales order is not generated.

localhost:7048/<server instance>/OData/Company('CRONUS-International-Ltd.')/SalesOrder?$expand= SalesOrderCustomer

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MahGah 15,607 on at

Like (0)

Report
Copy link

Link copied!

Hi

Look for Sell To Customer No in page 42 and then link it to No, in page 22. Then you can build the relationship.

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1

OussamaSabbouh 1,969 Super User 2026 Season 1

#2

YUN ZHU 1,143 Super User 2026 Season 1

#3

Khushbu Rajvi. 688 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans