Subject Setting Master/Detail with TIBO Datasets
Author gjannotti
I have the scenario:
2 TIBOQuery´s with a Master/Detail relationship.

The first (master) is set to table COMPRAS with the structure above:
ID INTEGER PK
NUMERO INTEGER
COD_FORNECEDOR INTEGER FK(FORNECEDORES)
VALOR NUMERIC(10,2)

The PK (ID) is a autoincrement field with a generator set into the
before_insert trigger.

The second (detail) is set to table ITENSCOMPRAS with the structure
above:
ID INTEGER PK
ID_COMPRA INTEGER FK(COMPRAS)
COD_PRODUTO INTEGER FK(PRODUTOS)
QTD INTEGER
PRECO NUMERIC(10,2)

The PK (ID) is a autoincrement field with a generator set into the
before_insert trigger.

Why can i configure these two Datasets properties (KEYLINKS...) to
the master/detail relation work whell.

The biggest problem is: The detail table isn´t getting the value of
the field ID of the table COMPRAS.
I have set the propertie GeneratorLink of the table COMPRAS to get
the value of the last value of the Generator, but it don´t work to
the detail rows.

[]´s
Glaucio Jannotti