Subject [2] Re: [IBO] Primary Key
Author Helen Borrie
*** and, I forgot to add, the MasterSource property of Query2 is Query1. ****

At 11:39 AM 12-03-01 -0300, you wrote:
>Hello all,
>
>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.

A master-detail relationship?

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
_______________________________________________________