How to create a Primary foriegn key because there is no PFK in account for Op

How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship

Question Posted / rkreddy

2 Answers
7150 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / madhuri motwani

Hello,
I assume that 1: M in this case is 1 account linked to many
opptys. and the reason you would be need a PRIMARY pty
becuase opportunity would be an MVG on Account applets

You can use any column to create a PFK column. Use any
unused field in S_ORG_EXT or S_ORG_EXT_X to create a
field "Primary Opportunity Id"

On the table level, on S_ORG_EXT, set the Foreign Key Table
as S_OPTY for the chosen field

On the BC,
1. Create a new field "primary Oppty id"
2. create a link between the two BCs and set the Primary Id
field as above

Is This Answer Correct ?

2 Yes

1 No

How to create a Primary foriegn key because there is no PFK in account for Opprtunity ,it is 1:M ..

Answer / shankar

it is not possible to create in account for opty. the reason
is you were not aware of the entities (say what is contact,
opty,account,activity) Opty is a lead through which we
generate income. account is an organization it can be
internal or external. You are trying reversal that is not
possible

Is This Answer Correct ?

1 Yes

0 No

Post New Answer