dual relationship?

[Ruslan Zasukhin]

on 12/8/03 1:54 AM, Tim Davis at timdavis at amug.org wrote:

Hi Tim,

>   Is it possible to create two relationships between two tables?
> 
> 1. TableA.RecID    1:M    TableB.A_Ptr
> 2. TableA.B_Ptr    1:1    TableB.RecID

Yes of course!

Just then in SQL you must explicitly show which one to use for join


> The reason for this is, the first relationship is most appropriate,
> while the second allows me to pick up details from the first (of many)
> related child records, and then use it in a baseobject method.



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