Hello,

I have a list of customers (account) and a list of events (personalized
entity). I would like to make a relation of N to N between the 2, i.e. that
a customer can belong to several events and an event can be associated
several customers. Would you know how to set up a relation N to N in CRM
insofar as by defect only relations 1 with N are possible.

Thank you by advance.

RE: Relation N to N between entities by lsoares

lsoares
Thu Jul 27 03:15:01 CDT 2006

Hi,
You have to create a custom entity to establish that kind of relation...

account 1 --- n custom entity n --- 1 list of events

"Davyd" wrote:

> Hello,
>
> I have a list of customers (account) and a list of events (personalized
> entity). I would like to make a relation of N to N between the 2, i.e. that
> a customer can belong to several events and an event can be associated
> several customers. Would you know how to set up a relation N to N in CRM
> insofar as by defect only relations 1 with N are possible.
>
> Thank you by advance.
>
>
>

Re: Relation N to N between entities by Davyd

Davyd
Thu Jul 27 04:03:18 CDT 2006

Hi,

thank you for your response : I tried to create a custom entity but I can't
establish a relation like this :
You have two type of entites A and B

A can have N entities B
B can have N entities A

I tried but it doesn't work it's only "parental" relation.
For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
associated, I only can add new entities.
I only have the choice to create a new entity and I can"t associate an
existing entity.

I hope I'm clear (It's difficult I'm french and I have some problems to
explain clearly what I want sorry).

Thnak you by advance.

"lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> Hi,
> You have to create a custom entity to establish that kind of relation...
>
> account 1 --- n custom entity n --- 1 list of events
>
> "Davyd" wrote:
>
>> Hello,
>>
>> I have a list of customers (account) and a list of events (personalized
>> entity). I would like to make a relation of N to N between the 2, i.e.
>> that
>> a customer can belong to several events and an event can be associated
>> several customers. Would you know how to set up a relation N to N in CRM
>> insofar as by defect only relations 1 with N are possible.
>>
>> Thank you by advance.
>>
>>
>>



Re: Relation N to N between entities by dejan

dejan
Thu Jul 27 04:37:42 CDT 2006

Davyd, I think you did not understand Isoares correctly.

If you want to create m:n realtionship you have to create a
"connecting" entity that connects the two entites together. I'll put an
example:

You already have an entity called "Contact" and you create new entity
"Car". You want to assign what person can drive which car. So one
person can drive many cars and one car is driven by more persons.

You have to create a new entity "Contact Car" that connects Contacts
and Cars
In the "Contact Car" entity create two "Many-to-1" relationships. One
to the Contact and the other to the Car. Put the two attributes created
when you add a relationhip to the form and views.

Publish customizations.

When you open a contact, new item (User Cars) is displayed inthe left
menu.

Each link between a user and a car creates a new entity instance.


--
Dejan Dular



Davyd wrote:
> Hi,
>
> thank you for your response : I tried to create a custom entity but I can=
't
> establish a relation like this :
> You have two type of entites A and B
>
> A can have N entities B
> B can have N entities A
>
> I tried but it doesn't work it's only "parental" relation.
> For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> associated, I only can add new entities.
> I only have the choice to create a new entity and I can"t associate an
> existing entity.
>
> I hope I'm clear (It's difficult I'm french and I have some problems to
> explain clearly what I want sorry).
>
> Thnak you by advance.
>
> "lsoares" <lsoares@discussions.microsoft.com> a =E9crit dans le message de
> news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > Hi,
> > You have to create a custom entity to establish that kind of relation...
> >
> > account 1 --- n custom entity n --- 1 list of events
> >
> > "Davyd" wrote:
> >
> >> Hello,
> >>
> >> I have a list of customers (account) and a list of events (personalized
> >> entity). I would like to make a relation of N to N between the 2, i.e.
> >> that
> >> a customer can belong to several events and an event can be associated
> >> several customers. Would you know how to set up a relation N to N in C=
RM
> >> insofar as by defect only relations 1 with N are possible.
> >>
> >> Thank you by advance.
> >>
> >>
> >>


Re: Relation N to N between entities by Davyd

Davyd
Thu Jul 27 04:51:03 CDT 2006

I just tried this pretence. It works very well thank you.
So we can"t do that "immediatly" and we have to create a "connecting" entity
?

Thank you !!

<dejan.dular@gmail.com> a écrit dans le message de news:
1153993062.658703.316520@m79g2000cwm.googlegroups.com...
Davyd, I think you did not understand Isoares correctly.

If you want to create m:n realtionship you have to create a
"connecting" entity that connects the two entites together. I'll put an
example:

You already have an entity called "Contact" and you create new entity
"Car". You want to assign what person can drive which car. So one
person can drive many cars and one car is driven by more persons.

You have to create a new entity "Contact Car" that connects Contacts
and Cars
In the "Contact Car" entity create two "Many-to-1" relationships. One
to the Contact and the other to the Car. Put the two attributes created
when you add a relationhip to the form and views.

Publish customizations.

When you open a contact, new item (User Cars) is displayed inthe left
menu.

Each link between a user and a car creates a new entity instance.


--
Dejan Dular



Davyd wrote:
> Hi,
>
> thank you for your response : I tried to create a custom entity but I
> can't
> establish a relation like this :
> You have two type of entites A and B
>
> A can have N entities B
> B can have N entities A
>
> I tried but it doesn't work it's only "parental" relation.
> For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> associated, I only can add new entities.
> I only have the choice to create a new entity and I can"t associate an
> existing entity.
>
> I hope I'm clear (It's difficult I'm french and I have some problems to
> explain clearly what I want sorry).
>
> Thnak you by advance.
>
> "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > Hi,
> > You have to create a custom entity to establish that kind of relation...
> >
> > account 1 --- n custom entity n --- 1 list of events
> >
> > "Davyd" wrote:
> >
> >> Hello,
> >>
> >> I have a list of customers (account) and a list of events (personalized
> >> entity). I would like to make a relation of N to N between the 2, i.e.
> >> that
> >> a customer can belong to several events and an event can be associated
> >> several customers. Would you know how to set up a relation N to N in
> >> CRM
> >> insofar as by defect only relations 1 with N are possible.
> >>
> >> Thank you by advance.
> >>
> >>
> >>



Re: Relation N to N between entities by lsoares

lsoares
Thu Jul 27 07:01:01 CDT 2006

Hey,
Sorry... i didnt explained very well, but english isnt my main language to
;) Thx dejan for the help ;)

Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
work around. ;)

"Davyd" wrote:

> I just tried this pretence. It works very well thank you.
> So we can"t do that "immediatly" and we have to create a "connecting" entity
> ?
>
> Thank you !!
>
> <dejan.dular@gmail.com> a écrit dans le message de news:
> 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> Davyd, I think you did not understand Isoares correctly.
>
> If you want to create m:n realtionship you have to create a
> "connecting" entity that connects the two entites together. I'll put an
> example:
>
> You already have an entity called "Contact" and you create new entity
> "Car". You want to assign what person can drive which car. So one
> person can drive many cars and one car is driven by more persons.
>
> You have to create a new entity "Contact Car" that connects Contacts
> and Cars
> In the "Contact Car" entity create two "Many-to-1" relationships. One
> to the Contact and the other to the Car. Put the two attributes created
> when you add a relationhip to the form and views.
>
> Publish customizations.
>
> When you open a contact, new item (User Cars) is displayed inthe left
> menu.
>
> Each link between a user and a car creates a new entity instance.
>
>
> --
> Dejan Dular
>
>
>
> Davyd wrote:
> > Hi,
> >
> > thank you for your response : I tried to create a custom entity but I
> > can't
> > establish a relation like this :
> > You have two type of entites A and B
> >
> > A can have N entities B
> > B can have N entities A
> >
> > I tried but it doesn't work it's only "parental" relation.
> > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> > associated, I only can add new entities.
> > I only have the choice to create a new entity and I can"t associate an
> > existing entity.
> >
> > I hope I'm clear (It's difficult I'm french and I have some problems to
> > explain clearly what I want sorry).
> >
> > Thnak you by advance.
> >
> > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > Hi,
> > > You have to create a custom entity to establish that kind of relation...
> > >
> > > account 1 --- n custom entity n --- 1 list of events
> > >
> > > "Davyd" wrote:
> > >
> > >> Hello,
> > >>
> > >> I have a list of customers (account) and a list of events (personalized
> > >> entity). I would like to make a relation of N to N between the 2, i.e.
> > >> that
> > >> a customer can belong to several events and an event can be associated
> > >> several customers. Would you know how to set up a relation N to N in
> > >> CRM
> > >> insofar as by defect only relations 1 with N are possible.
> > >>
> > >> Thank you by advance.
> > >>
> > >>
> > >>
>
>
>

Re: Relation N to N between entities by Ste

Ste
Thu Jul 27 09:55:02 CDT 2006

I have created a custom Entity - "Inventory"
This has a relationship with Accounts which is used to show the location of
a piece of hardware - a lookup field is used to choose an account. All good.

However I'd also like to have a couple of other lookups for Supplier and
Manufacturer. These are both stored in Accounts so they'd need to reference
an entry in Accounts again.

Is this possible? I know you cannot create multiple relationships between
entities but can you create multiple attributes using the one relationship?


"lsoares" wrote:

> Hey,
> Sorry... i didnt explained very well, but english isnt my main language to
> ;) Thx dejan for the help ;)
>
> Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
> work around. ;)
>
> "Davyd" wrote:
>
> > I just tried this pretence. It works very well thank you.
> > So we can"t do that "immediatly" and we have to create a "connecting" entity
> > ?
> >
> > Thank you !!
> >
> > <dejan.dular@gmail.com> a écrit dans le message de news:
> > 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> > Davyd, I think you did not understand Isoares correctly.
> >
> > If you want to create m:n realtionship you have to create a
> > "connecting" entity that connects the two entites together. I'll put an
> > example:
> >
> > You already have an entity called "Contact" and you create new entity
> > "Car". You want to assign what person can drive which car. So one
> > person can drive many cars and one car is driven by more persons.
> >
> > You have to create a new entity "Contact Car" that connects Contacts
> > and Cars
> > In the "Contact Car" entity create two "Many-to-1" relationships. One
> > to the Contact and the other to the Car. Put the two attributes created
> > when you add a relationhip to the form and views.
> >
> > Publish customizations.
> >
> > When you open a contact, new item (User Cars) is displayed inthe left
> > menu.
> >
> > Each link between a user and a car creates a new entity instance.
> >
> >
> > --
> > Dejan Dular
> >
> >
> >
> > Davyd wrote:
> > > Hi,
> > >
> > > thank you for your response : I tried to create a custom entity but I
> > > can't
> > > establish a relation like this :
> > > You have two type of entites A and B
> > >
> > > A can have N entities B
> > > B can have N entities A
> > >
> > > I tried but it doesn't work it's only "parental" relation.
> > > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> > > associated, I only can add new entities.
> > > I only have the choice to create a new entity and I can"t associate an
> > > existing entity.
> > >
> > > I hope I'm clear (It's difficult I'm french and I have some problems to
> > > explain clearly what I want sorry).
> > >
> > > Thnak you by advance.
> > >
> > > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> > > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > > Hi,
> > > > You have to create a custom entity to establish that kind of relation...
> > > >
> > > > account 1 --- n custom entity n --- 1 list of events
> > > >
> > > > "Davyd" wrote:
> > > >
> > > >> Hello,
> > > >>
> > > >> I have a list of customers (account) and a list of events (personalized
> > > >> entity). I would like to make a relation of N to N between the 2, i.e.
> > > >> that
> > > >> a customer can belong to several events and an event can be associated
> > > >> several customers. Would you know how to set up a relation N to N in
> > > >> CRM
> > > >> insofar as by defect only relations 1 with N are possible.
> > > >>
> > > >> Thank you by advance.
> > > >>
> > > >>
> > > >>
> >
> >
> >

Re: Relation N to N between entities by Matt

Matt
Thu Jul 27 14:06:22 CDT 2006

Ansered above.

--

Matt Parks
MVP - Microsoft CRM


"Ste" <Ste@discussions.microsoft.com> wrote in message
news:729FEB23-FA0F-4A96-BAF8-8B383E48C0E2@microsoft.com...
I have created a custom Entity - "Inventory"
This has a relationship with Accounts which is used to show the location of
a piece of hardware - a lookup field is used to choose an account. All good.

However I'd also like to have a couple of other lookups for Supplier and
Manufacturer. These are both stored in Accounts so they'd need to reference
an entry in Accounts again.

Is this possible? I know you cannot create multiple relationships between
entities but can you create multiple attributes using the one relationship?


"lsoares" wrote:

> Hey,
> Sorry... i didnt explained very well, but english isnt my main language to
> ;) Thx dejan for the help ;)
>
> Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
> work around. ;)
>
> "Davyd" wrote:
>
> > I just tried this pretence. It works very well thank you.
> > So we can"t do that "immediatly" and we have to create a "connecting"
> > entity
> > ?
> >
> > Thank you !!
> >
> > <dejan.dular@gmail.com> a écrit dans le message de news:
> > 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> > Davyd, I think you did not understand Isoares correctly.
> >
> > If you want to create m:n realtionship you have to create a
> > "connecting" entity that connects the two entites together. I'll put an
> > example:
> >
> > You already have an entity called "Contact" and you create new entity
> > "Car". You want to assign what person can drive which car. So one
> > person can drive many cars and one car is driven by more persons.
> >
> > You have to create a new entity "Contact Car" that connects Contacts
> > and Cars
> > In the "Contact Car" entity create two "Many-to-1" relationships. One
> > to the Contact and the other to the Car. Put the two attributes created
> > when you add a relationhip to the form and views.
> >
> > Publish customizations.
> >
> > When you open a contact, new item (User Cars) is displayed inthe left
> > menu.
> >
> > Each link between a user and a car creates a new entity instance.
> >
> >
> > --
> > Dejan Dular
> >
> >
> >
> > Davyd wrote:
> > > Hi,
> > >
> > > thank you for your response : I tried to create a custom entity but I
> > > can't
> > > establish a relation like this :
> > > You have two type of entites A and B
> > >
> > > A can have N entities B
> > > B can have N entities A
> > >
> > > I tried but it doesn't work it's only "parental" relation.
> > > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and
> > > A2
> > > associated, I only can add new entities.
> > > I only have the choice to create a new entity and I can"t associate an
> > > existing entity.
> > >
> > > I hope I'm clear (It's difficult I'm french and I have some problems
> > > to
> > > explain clearly what I want sorry).
> > >
> > > Thnak you by advance.
> > >
> > > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message
> > > de
> > > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > > Hi,
> > > > You have to create a custom entity to establish that kind of
> > > > relation...
> > > >
> > > > account 1 --- n custom entity n --- 1 list of events
> > > >
> > > > "Davyd" wrote:
> > > >
> > > >> Hello,
> > > >>
> > > >> I have a list of customers (account) and a list of events
> > > >> (personalized
> > > >> entity). I would like to make a relation of N to N between the 2,
> > > >> i.e.
> > > >> that
> > > >> a customer can belong to several events and an event can be
> > > >> associated
> > > >> several customers. Would you know how to set up a relation N to N
> > > >> in
> > > >> CRM
> > > >> insofar as by defect only relations 1 with N are possible.
> > > >>
> > > >> Thank you by advance.
> > > >>
> > > >>
> > > >>
> >
> >
> >



Re: Relation N to N between entities by lsoares

lsoares
Fri Jul 28 06:32:02 CDT 2006

Hi,

I think you can do it using mappings... i didnt tryed yet myself but i think
its for what they are used...

on the customized entity click relationships then mappings...

"Ste" wrote:

> I have created a custom Entity - "Inventory"
> This has a relationship with Accounts which is used to show the location of
> a piece of hardware - a lookup field is used to choose an account. All good.
>
> However I'd also like to have a couple of other lookups for Supplier and
> Manufacturer. These are both stored in Accounts so they'd need to reference
> an entry in Accounts again.
>
> Is this possible? I know you cannot create multiple relationships between
> entities but can you create multiple attributes using the one relationship?
>
>
> "lsoares" wrote:
>
> > Hey,
> > Sorry... i didnt explained very well, but english isnt my main language to
> > ;) Thx dejan for the help ;)
> >
> > Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
> > work around. ;)
> >
> > "Davyd" wrote:
> >
> > > I just tried this pretence. It works very well thank you.
> > > So we can"t do that "immediatly" and we have to create a "connecting" entity
> > > ?
> > >
> > > Thank you !!
> > >
> > > <dejan.dular@gmail.com> a écrit dans le message de news:
> > > 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> > > Davyd, I think you did not understand Isoares correctly.
> > >
> > > If you want to create m:n realtionship you have to create a
> > > "connecting" entity that connects the two entites together. I'll put an
> > > example:
> > >
> > > You already have an entity called "Contact" and you create new entity
> > > "Car". You want to assign what person can drive which car. So one
> > > person can drive many cars and one car is driven by more persons.
> > >
> > > You have to create a new entity "Contact Car" that connects Contacts
> > > and Cars
> > > In the "Contact Car" entity create two "Many-to-1" relationships. One
> > > to the Contact and the other to the Car. Put the two attributes created
> > > when you add a relationhip to the form and views.
> > >
> > > Publish customizations.
> > >
> > > When you open a contact, new item (User Cars) is displayed inthe left
> > > menu.
> > >
> > > Each link between a user and a car creates a new entity instance.
> > >
> > >
> > > --
> > > Dejan Dular
> > >
> > >
> > >
> > > Davyd wrote:
> > > > Hi,
> > > >
> > > > thank you for your response : I tried to create a custom entity but I
> > > > can't
> > > > establish a relation like this :
> > > > You have two type of entites A and B
> > > >
> > > > A can have N entities B
> > > > B can have N entities A
> > > >
> > > > I tried but it doesn't work it's only "parental" relation.
> > > > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> > > > associated, I only can add new entities.
> > > > I only have the choice to create a new entity and I can"t associate an
> > > > existing entity.
> > > >
> > > > I hope I'm clear (It's difficult I'm french and I have some problems to
> > > > explain clearly what I want sorry).
> > > >
> > > > Thnak you by advance.
> > > >
> > > > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> > > > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > > > Hi,
> > > > > You have to create a custom entity to establish that kind of relation...
> > > > >
> > > > > account 1 --- n custom entity n --- 1 list of events
> > > > >
> > > > > "Davyd" wrote:
> > > > >
> > > > >> Hello,
> > > > >>
> > > > >> I have a list of customers (account) and a list of events (personalized
> > > > >> entity). I would like to make a relation of N to N between the 2, i.e.
> > > > >> that
> > > > >> a customer can belong to several events and an event can be associated
> > > > >> several customers. Would you know how to set up a relation N to N in
> > > > >> CRM
> > > > >> insofar as by defect only relations 1 with N are possible.
> > > > >>
> > > > >> Thank you by advance.
> > > > >>
> > > > >>
> > > > >>
> > >
> > >
> > >

Re: Relation N to N between entities by lsoares

lsoares
Fri Jul 28 06:34:02 CDT 2006

Ops sorry relationships, pick relation then mappings...

"lsoares" wrote:

> Hi,
>
> I think you can do it using mappings... i didnt tryed yet myself but i think
> its for what they are used...
>
> on the customized entity click relationships then mappings...
>
> "Ste" wrote:
>
> > I have created a custom Entity - "Inventory"
> > This has a relationship with Accounts which is used to show the location of
> > a piece of hardware - a lookup field is used to choose an account. All good.
> >
> > However I'd also like to have a couple of other lookups for Supplier and
> > Manufacturer. These are both stored in Accounts so they'd need to reference
> > an entry in Accounts again.
> >
> > Is this possible? I know you cannot create multiple relationships between
> > entities but can you create multiple attributes using the one relationship?
> >
> >
> > "lsoares" wrote:
> >
> > > Hey,
> > > Sorry... i didnt explained very well, but english isnt my main language to
> > > ;) Thx dejan for the help ;)
> > >
> > > Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
> > > work around. ;)
> > >
> > > "Davyd" wrote:
> > >
> > > > I just tried this pretence. It works very well thank you.
> > > > So we can"t do that "immediatly" and we have to create a "connecting" entity
> > > > ?
> > > >
> > > > Thank you !!
> > > >
> > > > <dejan.dular@gmail.com> a écrit dans le message de news:
> > > > 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> > > > Davyd, I think you did not understand Isoares correctly.
> > > >
> > > > If you want to create m:n realtionship you have to create a
> > > > "connecting" entity that connects the two entites together. I'll put an
> > > > example:
> > > >
> > > > You already have an entity called "Contact" and you create new entity
> > > > "Car". You want to assign what person can drive which car. So one
> > > > person can drive many cars and one car is driven by more persons.
> > > >
> > > > You have to create a new entity "Contact Car" that connects Contacts
> > > > and Cars
> > > > In the "Contact Car" entity create two "Many-to-1" relationships. One
> > > > to the Contact and the other to the Car. Put the two attributes created
> > > > when you add a relationhip to the form and views.
> > > >
> > > > Publish customizations.
> > > >
> > > > When you open a contact, new item (User Cars) is displayed inthe left
> > > > menu.
> > > >
> > > > Each link between a user and a car creates a new entity instance.
> > > >
> > > >
> > > > --
> > > > Dejan Dular
> > > >
> > > >
> > > >
> > > > Davyd wrote:
> > > > > Hi,
> > > > >
> > > > > thank you for your response : I tried to create a custom entity but I
> > > > > can't
> > > > > establish a relation like this :
> > > > > You have two type of entites A and B
> > > > >
> > > > > A can have N entities B
> > > > > B can have N entities A
> > > > >
> > > > > I tried but it doesn't work it's only "parental" relation.
> > > > > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> > > > > associated, I only can add new entities.
> > > > > I only have the choice to create a new entity and I can"t associate an
> > > > > existing entity.
> > > > >
> > > > > I hope I'm clear (It's difficult I'm french and I have some problems to
> > > > > explain clearly what I want sorry).
> > > > >
> > > > > Thnak you by advance.
> > > > >
> > > > > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> > > > > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > > > > Hi,
> > > > > > You have to create a custom entity to establish that kind of relation...
> > > > > >
> > > > > > account 1 --- n custom entity n --- 1 list of events
> > > > > >
> > > > > > "Davyd" wrote:
> > > > > >
> > > > > >> Hello,
> > > > > >>
> > > > > >> I have a list of customers (account) and a list of events (personalized
> > > > > >> entity). I would like to make a relation of N to N between the 2, i.e.
> > > > > >> that
> > > > > >> a customer can belong to several events and an event can be associated
> > > > > >> several customers. Would you know how to set up a relation N to N in
> > > > > >> CRM
> > > > > >> insofar as by defect only relations 1 with N are possible.
> > > > > >>
> > > > > >> Thank you by advance.
> > > > > >>
> > > > > >>
> > > > > >>
> > > >
> > > >
> > > >

Re: Relation N to N between entities by lsoares

lsoares
Fri Jul 28 06:49:01 CDT 2006

I think that there are already 1 post about here:
http://www.microsoft.com/businesssolutions/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.crm&tid=083ad29f-002c-4c3f-8529-9afe52bb949c

"lsoares" wrote:

> Hi,
>
> I think you can do it using mappings... i didnt tryed yet myself but i think
> its for what they are used...
>
> on the customized entity click relationships then mappings...
>
> "Ste" wrote:
>
> > I have created a custom Entity - "Inventory"
> > This has a relationship with Accounts which is used to show the location of
> > a piece of hardware - a lookup field is used to choose an account. All good.
> >
> > However I'd also like to have a couple of other lookups for Supplier and
> > Manufacturer. These are both stored in Accounts so they'd need to reference
> > an entry in Accounts again.
> >
> > Is this possible? I know you cannot create multiple relationships between
> > entities but can you create multiple attributes using the one relationship?
> >
> >
> > "lsoares" wrote:
> >
> > > Hey,
> > > Sorry... i didnt explained very well, but english isnt my main language to
> > > ;) Thx dejan for the help ;)
> > >
> > > Yes MS CRM 3.0 dont support directly that kind of relation, so we have to
> > > work around. ;)
> > >
> > > "Davyd" wrote:
> > >
> > > > I just tried this pretence. It works very well thank you.
> > > > So we can"t do that "immediatly" and we have to create a "connecting" entity
> > > > ?
> > > >
> > > > Thank you !!
> > > >
> > > > <dejan.dular@gmail.com> a écrit dans le message de news:
> > > > 1153993062.658703.316520@m79g2000cwm.googlegroups.com...
> > > > Davyd, I think you did not understand Isoares correctly.
> > > >
> > > > If you want to create m:n realtionship you have to create a
> > > > "connecting" entity that connects the two entites together. I'll put an
> > > > example:
> > > >
> > > > You already have an entity called "Contact" and you create new entity
> > > > "Car". You want to assign what person can drive which car. So one
> > > > person can drive many cars and one car is driven by more persons.
> > > >
> > > > You have to create a new entity "Contact Car" that connects Contacts
> > > > and Cars
> > > > In the "Contact Car" entity create two "Many-to-1" relationships. One
> > > > to the Contact and the other to the Car. Put the two attributes created
> > > > when you add a relationhip to the form and views.
> > > >
> > > > Publish customizations.
> > > >
> > > > When you open a contact, new item (User Cars) is displayed inthe left
> > > > menu.
> > > >
> > > > Each link between a user and a car creates a new entity instance.
> > > >
> > > >
> > > > --
> > > > Dejan Dular
> > > >
> > > >
> > > >
> > > > Davyd wrote:
> > > > > Hi,
> > > > >
> > > > > thank you for your response : I tried to create a custom entity but I
> > > > > can't
> > > > > establish a relation like this :
> > > > > You have two type of entites A and B
> > > > >
> > > > > A can have N entities B
> > > > > B can have N entities A
> > > > >
> > > > > I tried but it doesn't work it's only "parental" relation.
> > > > > For example if A have B1, B1 and B3 associated B1 can't have A, A1 and A2
> > > > > associated, I only can add new entities.
> > > > > I only have the choice to create a new entity and I can"t associate an
> > > > > existing entity.
> > > > >
> > > > > I hope I'm clear (It's difficult I'm french and I have some problems to
> > > > > explain clearly what I want sorry).
> > > > >
> > > > > Thnak you by advance.
> > > > >
> > > > > "lsoares" <lsoares@discussions.microsoft.com> a écrit dans le message de
> > > > > news: EE55DD79-0A5B-4C1F-B499-34733014E885@microsoft.com...
> > > > > > Hi,
> > > > > > You have to create a custom entity to establish that kind of relation...
> > > > > >
> > > > > > account 1 --- n custom entity n --- 1 list of events
> > > > > >
> > > > > > "Davyd" wrote:
> > > > > >
> > > > > >> Hello,
> > > > > >>
> > > > > >> I have a list of customers (account) and a list of events (personalized
> > > > > >> entity). I would like to make a relation of N to N between the 2, i.e.
> > > > > >> that
> > > > > >> a customer can belong to several events and an event can be associated
> > > > > >> several customers. Would you know how to set up a relation N to N in
> > > > > >> CRM
> > > > > >> insofar as by defect only relations 1 with N are possible.
> > > > > >>
> > > > > >> Thank you by advance.
> > > > > >>
> > > > > >>
> > > > > >>
> > > >
> > > >
> > > >