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
How to call external webpage from siebel application?
How do you display the number of records in a picklist(combo box/drop down) not the records in the pickapplet, in just 3 rows and not 5 rows(which is the default)?
How to Get the MultiValueFields in Workflow
Dynamic picklist is used to update join fields? How?
how do you specify a view to be displayed as aggregate view in siebel 7.7?
Explain how to find entity relation in siebel tools?
What is applet toggle and how many types are there?
Suppose if a view has admin mode property = true, then what will happen to user properties we write on them?
How is Siebel x data model is different from Siebel 0 data model?
i want interview question on siebel testing.very urgent
How will you do validations in escripts and in configuration?
What's siebel?
What is inbound in picklist?
when you have pre default value and post default value for a field, which one will be stored in the database?
What is the difference in the architecture of Siebel x and Siebel x?