Relations

[Roger Amar]

Hello Ruslan,

Thank you.
> To link you need assign into BO1Ptr field some RecId value of BO1.
May I assign another field like "NumVolumes" in place of recID ?

Best regards,

Roger;



> 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.
May I assign another field like "NumVolumes" ?


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
-------------------------------------------------------------


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina