In article <829955203.20020130181609@...>, "Geoff
Worboys (TeamIBO)" <geoff@...> wrote:

> I cant tell you how to do that without more information, such as what
> the actual join sql is and what the keylinks are for that dataset. If
> you provide details of the join SQL involved and the keylinks that you
> use we may be able to help. We would also need to know how you are
> defining all fields in the keylinks - which presumably means giving
> details of the InsertSQL/stored-procedure that you are using.

PERSON table contains all personal info, and AGENT contains all agents
and since agents are people (most anyway!), the information on an agent
is contained in a record in both tables.

AGENT:
SQL - select
A.AGENTKEY,P.LNAME,P.FNAME,A.BUSERID,A.BPASSWORD,A.PRIVLEVEL,P.PERSONKEY,P.CLIENTKEY
from MBAGENT A join MBPERSON P on A.AGENTKEY=P.CLIENTKEY order by P.LNAME,P.FNAME
KeyLinks - AGENTKEY
GeneratorLink - AGENTKEY=MB_KEY
InsertSQL - execute procedure
SP_AGENTADD(:LNAME,:FNAME,:BUSERID,:BPASSWORD,:PRIVLEVEL)

PERSON:
SQL - select PERSONKEY,CLIENTKEY,LNAME,FNAME from MBPERSON
KeySource - dsAgent
KeyLinks - MBPERSON.CLIENTKEY=MBAGENT.AGENTKEY
GeneratorLink - PERSONKEY=MB_KEY

THe problem is that, when the user hits the insert button on the AGENT
UpdateBar construct, a new record is generated in the AGENT table, but not in
the PERSON table. I need records created in both tables.

Thanks. Eric.