mahudeswaran

• Mar 31st, 2006

 

m to m relation ship

m to 1 1 to m

this way you can join

mahudes

Dr. Suresh Rajappa PhD PMP MCP

• Apr 3rd, 2006

 

if you have two tables with many to many relation ship, take the keys of those tables and form a 1-1 relationship table. then you can connect both the existing tables to the newly formed table using the key.

ALuthra

 Profile Answers by ALuthra 

• Aug 10th, 2006

 

Create an intermediate table with 2 keys .. i.e., the primary keys of both tables. Join each table to its primary key in the intermediate table.

MrExpert

• May 12th, 2007

 

You can achieve  this by creating two data provider having one field common and linking them using the property in 'viewdata'

ASHOK1324

 Profile Answers by ASHOK1324 

• Apr 19th, 2009

 

In BO universe designer, Drag the column of first table to the corresponding column of second table or simply go to Insert->Join to create a join between 2 tables. You can change the cardinality from n-n [many to many] or 1-n or n-1 or 1-1 and Click on "Detect". But, n-n cardinality creates loops. In BO, It is always best to use 1-n cardinality for fast data retrieval. Always delete the unnecessary joins which have n-n cardinalty.