How to create a Primary foriegn key because there is no PFK
in account for Opprtunity ,it is 1:M relationship
- 2 Answers
- 7311 Views
- I also Faced
- E-Mail Answers
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
When do you use genbscript.exe?
What is an extension table?
Explain the steps required to implement the load balancer on siebel servers.
What is eapps.cfg file?
How would you find entity relation in siebel tools?
Tell me is it posible to access more than one database at a single siebel application?
How to find out new vanilla functionality in SIEBEL 7.7 and 7.8?
Explain why do we need to create employees at the database in siebel?
What is complex join? Difference with foreign key primary key join?
What is caching in siebel?
Explain pick applet?
What value will get stored in the database when a field has both predefault value and post default value?
Explain about the eim tables and base tables are required to your entities?
Explain how is siebel 7.x data model is different from siebel 6.0 data model?
Explain when do you use genbscript.exe?
