Subject Newbie TIBOTABLE master-Detail
Author chirug2003
I've just started evaluating IBO and bought the 'Getting started
Guide'.
I've previously used Paradox.

I'm having difficulty with a simple test database I constructed to
learn
IBO.

Database contains 2 tables
MASTER
DETAIL

MASTER has 2 fields
ID Filled with a Generated value and required. Primary Key
CODETYPE VarChar(2) required with a default of 'PE'

DETAIL has 2 fields
ID Primary Key and Foreign Key on MASTER.ID required
COMMENT VarChar(20) not required

Set up a test form containing
TIBODatabase connected to TestDatabase
TIBOTable.MASTER with a Delphi VCL datasource (since I want to
use
InfoPower)
Keylinks: MASTER.ID
I have also set the Generator and Default values for the
MASTER.

TIBOTable.DETAIL with a VCL datasource
Keylinks: DETAIL.ID
MasterSource: MASTER
MasterLinks: DETAIL.ID=MASTER.ID

NavigatorBar connected to TIBOTable.MASTER datasource

Dripped simple VCL data-aware editing fields on the form for all the
fields
in MASTER and DETAIL.

Put MASTER into insert mode - MASTER.ID and MASTER.CODETYPE fill
automatically as expected

Start entering values into fields of DETAIL and DETAIL.ID fills with
the
value generated for MASTER.ID - fine so far DETAIL is automatically
going
into insert/edit mode. Once all DETAIL fields have been completed I
Press
the Post key on the navigator bar (which is attached to MASTER).

This is where my understanding of what should happen breaks down:-

MASTER posts correctly and remains displayed with it's values
DETAIL goes blank - all fields - with no error or other
messages. If I look at the table through a SQL utility it confirms
that no values are in DETAIL.

What has happened?

Peter