Re: Database Transformer Puzzle in Rel 2.1 of Designer 2000

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