How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is all mode sort?
What is the use of detailed category in configuration?
Is it possible to access more than one database at a single siebel application?
What are pre defined queries?
Explain what is nameserver?
Explain what is detailed category and what is its use in configuration?
Explain the use of catch in escript?
What exactly use of s_party concept in siebel?
What is detailed category?
Explain the function of nameserver?
Describe the 3 object explorer (oe) tabs?
Explain is it posible to access more than one database at a single siebel application?
in a three level hierarchial picklist say country,state,city how do we perform pickmap 2)say if we have values same for country (having value 'A') and for state (having value 'A') and for city having value 'B' and in parent Lic we give value for city as 'A' how do it recognise it as State any other solution
How is siebel 7.x architecture different from siebel 6.x? How is siebel 7.x architecture different from siebel 6.x?
What is the difference between vbc and ebc in siebel?