I think you need use SPs to do it.
Create SPs to insert,update and delete as you need.

Luiz.

----- Original Message -----
From: "Dion" <dion@...>
To: <IBObjects@yahoogroups.com>
Sent: Tuesday, January 15, 2002 2:02 PM
Subject: RE: [IBO] Join edit


> Hi All,
>
> What I want to do is present a GUI which to the user seems to be one
table.
> When the user inserts into the "main" table, the joined table is also
> updated(either inserted into if the key field is not found, or updated if
> any edits where done to the joined table as a whole). All fields from both
> tables must be editable in for eg a grid. How is this accomplished?
>
> Many Thanks,
> Dion.