Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

How to create multiple joins using same PK ?

2 posts in General Discussion Last posting was on 2012-08-27 16:17:03.0Z
Paul Williams Posted on 2012-08-01 10:19:13.0Z
Sender: 3411.5019006c.1804289383@sybase.com
From: Paul Williams
Newsgroups: sybase.public.powerdesigner.general
Subject: How to create multiple joins using same PK ?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <501902a1.3456.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 1 Aug 2012 03:19:13 -0700
X-Trace: forums-1-dub 1343816353 172.20.134.41 (1 Aug 2012 03:19:13 -0700)
X-Original-Trace: 1 Aug 2012 03:19:13 -0700, 172.20.134.41
Lines: 17
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30872
Article PK: 834249

I'm having trouble determining how to create multiple joins
using the same PK.

For example there is a Main table with several columns and a
Lookup table. Multiple columns in the main table are a FK to
the PK in the Lookup table i.e. col1 in the Main table is a
FK to the PK in the Lookup table and so is col2 in the Main
table.

In the CDM this is a 1 to many relationship between the
Lookup table and Main table which I can setup as a
reference. However, in the LDM I can setup in the Joins tab
a relationship between the PK in the Lookup table and col1
in the Main table but when I try to setup the second
relationship I cannot select the PK from the Lookup table
again.
It appears it allows it only to be used once ?


Gabor Gollnhofer Posted on 2012-08-27 16:17:03.0Z
From: "Gabor Gollnhofer" <donot@mail.me>
Newsgroups: sybase.public.powerdesigner.general
References: <501902a1.3456.1681692777@sybase.com>
Subject: Re: How to create multiple joins using same PK ?
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5931
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.6157
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <503b9d7f$1@forums-1-dub>
Date: 27 Aug 2012 09:17:03 -0700
X-Trace: forums-1-dub 1346084223 172.20.134.152 (27 Aug 2012 09:17:03 -0700)
X-Original-Trace: 27 Aug 2012 09:17:03 -0700, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.powerdesigner.general:30899
Article PK: 834276

Hi,

You have to create more relationships between the CDM Entities
as a single relationship means a single join.
The cardinality (1:1 or 1:M) of the relationship doesn't effect this.

HTH,

Gabor

> I'm having trouble determining how to create multiple joins
> using the same PK.
>
> For example there is a Main table with several columns and a
> Lookup table. Multiple columns in the main table are a FK to
> the PK in the Lookup table i.e. col1 in the Main table is a
> FK to the PK in the Lookup table and so is col2 in the Main
> table.
>
> In the CDM this is a 1 to many relationship between the
> Lookup table and Main table which I can setup as a
> reference. However, in the LDM I can setup in the Joins tab
> a relationship between the PK in the Lookup table and col1
> in the Main table but when I try to setup the second
> relationship I cannot select the PK from the Lookup table
> again.
> It appears it allows it only to be used once ?
>