Subject | [2] Re: [IBO] Primary Key |
---|---|
Author | Helen Borrie |
Post date | 2001-03-13T07:41:49Z |
*** and, I forgot to add, the MasterSource property of Query2 is Query1. ****
At 11:39 AM 12-03-01 -0300, you wrote:
Query1 (master) from TABLE1 has Keylinks entered like this:
COLUMN1
COLUMN2
That is, one line for each column in the primary key.
Query2 (detail) from TABLE2 has MasterLinks as:
TABLE1.COLUMN1
TABLE1.COLUMN2
and its own Keylinks will be whatever constitutes the primary key of Table2.
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
At 11:39 AM 12-03-01 -0300, you wrote:
>Hello all,A master-detail relationship?
>
>Do the property keylink accept only one column?
>I have a primary key with two columns.
>How I link two ib_querys using primary key with two columns? I want to use
>his properties.
Query1 (master) from TABLE1 has Keylinks entered like this:
COLUMN1
COLUMN2
That is, one line for each column in the primary key.
Query2 (detail) from TABLE2 has MasterLinks as:
TABLE1.COLUMN1
TABLE1.COLUMN2
and its own Keylinks will be whatever constitutes the primary key of Table2.
Cheers,
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________