Relations

[Ruslan Zasukhin]

On 2/12/05 2:06 AM, "Roger Amar" <Roger at logram.com> wrote:

> Hello,
> 
> I have 2 BaseObjects with fields like this :
> 
> BO1 :  NumVolume
> Title
> Author
> ...
> 
> BO2 :  NumVolume
> NumTracks
> SupportType
> ...
> 
> I would like to link the 2 BO in the purpose to get numTracks and
> SupportType when I select a record of BO1.
> I cannot find how to use the ObjectPtr to perform such link.
> 
> Can anyone help ?

Add into BO2 field of ObjectPtr type

> BO2 :     NumVolume
> NumTracks
> SupportType
  BO1Ptr of type ObjectPtr

To link you need assign into BO1Ptr field some RecId value of BO1.


Later in SQL you will do

    select ...
    from BO1, BO2
    WHERE BO1.recid = BO2.BO1Ptr


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------