Multiple Attributes - One Relationship

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?

Ste
Thu Jul 27 05:16:01 CDT 2006

Can anyone help with this - still got no further...

"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?

Matt
Thu Jul 27 14:02:24 CDT 2006

Typing multiple fields to the "same" relationship would have the affect of
setting all the values to the same Account. To accomplish what you need,
you need to have mutliple relationships (and thus multiple fields), which is
not supported.

--

Matt Parks
MVP - Microsoft CRM


"Ste" <Ste@discussions.microsoft.com> wrote in message
news:2D5E9025-647C-4FE9-AD2D-4D2784DCA336@microsoft.com...
Can anyone help with this - still got no further...

"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?