Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

Hi Nicholas,

I'm sorry. You mean ':' as manadatory and '|' as optional in your diagram in your previous message!

I saw crosses at the top of the crowfoots, but I always think about dotted lines as about optional relationship :) I mean '|' as mandatory, not ':'.

I just tested this situation in my Des2k 2.1.1 with Entity A and Entity C some minutes ago. Table C created without surrogate primary key column. With only one mandatory foreign key column as a primary key.

Can you archive, export and send me your small test application? I'll try to help you.

Good Luck.
Valery

Nicholas Wakefield wrote:
>
> Valaray
>
> Thankyou for your reply, however I had done this and my diagram tried to
> show this by means of the crosses at the tops of the crowfoots
> Valery A. Sorokin wrote in message <362C8A65.E8F4437_at_dd.ru>...
> >I think both Relationship Ends for Entity C must be mandatory
> >and with checked Primary UID check boxes.
> >
> > _____________ ___________
> > | Entity A | | Entity B |
> > |___________| |__________|
> > : :
> > : :
> > : :
> > | |
> > | |
> > _|_ _|_
> > /|\ /|\
> > _ /_|_\ ______________________/_|_\_
> > | Entity C |
> > |____________________________________|
> >
> >
> >
> >I hope this will help you.
> >
> >Nicholas Wakefield wrote:
> >>
> >> I have two versions of designer in my office 2.1 and 1.3.2 and when I
 create
> >> an application
> >> with the entity realtionship model like the one below, I get two
 completely
> >> different answers
> >> _________ _________
> >> | Entity A | | Entity B |
> >> |________| |_________|
> >> | |
> >> | |
> >> | |
> >> : :
> >> : :
> >> _:_ _:_
> >> /|\ /|\
> >> _ /_|_\ _______/_|_\_
> >> | Entity C |
> >> |________________|
> >>
> >> 1.3.2 - Creates two new foreign key columns in entity c, which form the
> >> primary key - which is what I want, when put through the database wizard.
> >> ...Whilst ...
> >> 2.1 - Creates a sequence identifier(surrogate) for the primary key and
> >> two optional foreign key columns entity c, when put through the database
> >> transformer.
> >>
> >> Could someone please tell me why as it has got me baffled.
> >>
> >> Regards
> >> Nicholas
> >
> >--
> >Valery A. Sorokin
> >ProSoft, Russia, Moscow, Information Systems Division
> >Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
> >E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
> >http://www.dd.ru
 

-- 
Valery A. Sorokin
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 (6 lines) FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru OR vsorokin_at_prosoftmpc.msk.su
http://www.dd.ru