Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested answer

Relate Tables from an OData Web Server

(0) ShareShare
ReportReport
Posted on by

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

  • Suggested answer
    MahGah Profile Picture
    15,437 on at
    RE: Relate Tables from an OData Web Server

    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.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,190 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,968 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans