How to define type 4 entity attribute as keyfield

[Former Member]

Hi Everyone,

I have a requirement to assign the attribute  of type 4 entity as key field, i tried checking the key field  checkbox but it throws error

"If you want to create a key field for the entity type 4, choose the Relationships view".

How to achieve this?

Regards,

Bhuvaneswari

[dilipan · Accepted solution]

You cannot make an attribute as Key Attribute in Type 4 entity.

You can achieve this by 2 ways

1.create the attribute (which you want to be a key field) as Type 3 entity and create a 'Qualifying' relationship between the type 3 entity and the type 4 entity.

2.Else, create the key field as type 1 entity and create a 'Leading' relationship between the type 1 entity and type 4 entity.

Both will add the field as key field to the Type 4 Entity.

Thanks and Regards,

Dilip

[Former Member · Accepted solution]

Hi Dilipan,

Thanks for the Reply,

You can achieve this by 2 ways

1.create the attribute (which you want to be a key field) as Type 3 entity and create a 'Qualifying' relationship between the type 3 entity and the type 4 entity.

-----For type 3 entity attribute should have check table or fixed values,but the attribute is text field

2.Else, create the key field as type 1 entity and create a 'Leading' relationship between the type 1 entity and type 4 entity.

-------Tried creating attribute as Type 1 entity but type 4 entity not allowing to assign more than one  leading relationship because type 4 entity assigns relationship with another type 1 entity.

Is there any another possibiltiy?

Regards,

Bhuvaneswari

[dilipan · Accepted solution]

Hi Bhuvaneswari,

If your business need permits, you can add the attribute to Type 1 entity and mark as key field.

Also you can add the attribute to the type 4 entity and set the 'Required Entry Field' so that the field will become mandatory field in the UI.

Regards,

Dilipan

[d024348 · Accepted solution]

Hi, concerning "should have check table or fixed values", check Type3 entity GUID of data model MM. No check table or fixed values here.

So Dilipan's 1st recommendation was correct.

Good luck, Ingo Bruß