Subject Re: [IBO] Join edit
Author Luiz
I think you need use SPs to do it.
Create SPs to insert,update and delete as you need.


----- Original Message -----
From: "Dion" <dion@...>
To: <>
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
> 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.