web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

RelationShip Type in d365fo

(0) ShareShare
ReportReport
Posted on by 56

Hi team,

Kindly explain me about relationship type properties on the table relation properties

pastedimage1679240720155v1.png

Which value when to select?

Suppose I have two tables -

Table A and Table B

I make the normal relation on Table B with Table A

Which RelationShip Type needs to select?

Pls give me more shed on this.

thanks!

I have the same question (0)
  • Martin Dráb Profile Picture
    239,634 Most Valuable Professional on at

    Your questions can't be answered, because type you should select depends on the logical relationship of those tables, and that unknown to us. It's you who need to think about it.

    If you don't know, for example, what "Composition" means, look at the internet. For example: What are the six types of relationships in UML class diagrams?.

  • @rp@n Profile Picture
    56 on at

    Sorry Not understand.

    I am not sure whether my question is correct or not.

    Kindly anyone please explain me from scratch relationship type in table relation .

    pls give me more shed on this

  • @rp@n Profile Picture
    56 on at

    can anyone explain on this?

  • huijij Profile Picture
    19,813 on at

    Hi sir,

    Please start with the following MS document describes the elements of the RelationshipType property.

    learn.microsoft.com/.../hh803131(v=ax.60)

    Here is an old thread for the same topic you can refer to:

    community.dynamics.com/.../relationship-type-in-d365fo

  • @rp@n Profile Picture
    56 on at

    Hi Judy,

    the link you provided

    Here is an old thread for the same topic you can refer to:

    community.dynamics.com/.../relationship-type-in-d365fo

    I only posted recently.

  • huijij Profile Picture
    19,813 on at

    Sorry for the wrong link, please check the thread for reference:

    community.dynamics.com/.../relationship-type-property

  • @rp@n Profile Picture
    56 on at

    Hi Judy, I go through that but not understand. 

    Kindly elaborate me please 

  • André Arnaud de Calavon Profile Picture
    305,155 Super User 2026 Season 1 on at

    Hi @rp@n,

    Martin and Judy provided links with information about relation types. Can you explain to us what exact part you are not understanding? To get your initial question answered, please provide details how these tables are related to each other. Table A and Table B are not clear to us. Table names like Sales order header and Sales order lines or Customers and Terms of Payment are clearer. Then we might be able to help you. Otherwise, you would need to understand the basics. Martin shared a link which should be helpful.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 797

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 610 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 534

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans