--- In IBObjects@y..., "Helen Borrie (TeamIBO)" <helebor@d...> wrote:

> At 05:38 AM 07-03-02 +0000, you wrote:
> >Hello,
> >
> > I have two tables:
> > AGENT - which stores all info specific to the real estate agent
> > PERSON - stores all personal info of everyone
> >
> > Since the AGENT is also a PERSON, I have to add to both tables

when

> >I want to add an AGENT.
>
> Yes indeed - the easy and proper way to do this is to have TWO

datasets

> linked in a master-detail relationship...no joined datasets are

either

> necessary or desirable. Your master set is a select from the

Person

> table. Your detail set (from the Agent table) uses its

Mastersource and

> Masterlinks properties to connect to the master and IBO takes care

of the

> rest. You don't need any funny UpdateSQL or storedprocedures or

whatever.

The problem with this 1:1 master-detail relationship is that both
datasets must be put into insert mode when the user hits the '+'
button. If PERSON is the master, then no problem. But when is the
AGENT dataset put into insert mode? This is where I have been having
trouble.

Eric.