Hi,

Have you tried using a TIB_LookupCombo in order to facilitate data entry
into the joined field/s? ie using it to display a drop down list of callers.
Would this also be possible if the lookup field was not the key, but a
unique index existed?

The reason why I want to do it this way, is because it will make data
capturing quicker and less complicated for the user. Faling this, I will
have to use a popup window for input I suppose.

Thanks,
Dion.

----- Original Message -----
From: <rvellacott@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, October 17, 2001 12:02 PM
Subject: Re: [IBO] Editing a JOIN - Andreas


> In the AfterOpen event of the query, switch off the ReadOnly of the
> joined fields. They then become editable in VCL controls. However,
> you have to stop the query from trying to post these fields, or it
> will give an error 'writing to read-only field'. Do this either by
> writing explicit EditSQL etc, or by making the fields readonly again
> (in code) before posting. You can post the values of the joined
> fields to their respective tables using update-queries in the
> BeforePost event of the main query.
>
> This may be a bit unconventional, and it's a dog to maintain, and may
> be disapproved of and unsupported in future versions, but it works.
>
> --- In IBObjects@y..., "Andreas Pohl" <apohl@i...> wrote:
> > Dion,
> >
> > no, it isn't possible. Inline selects are read/only. So if you want
> to edit joined fields, you have to use joins and EditSQL stuff etc.
> But my target was to avoid that.
> >
> > Mit freundlichem Gruss & Best Regards
> >
> > Andreas Pohl
> > apohl@i...
> > www.ibp-consult.com
> > ----- Original Message -----
> > From: "Dion" <dion@n...>
> > To: <IBObjects@y...>
> > Sent: Tuesday, October 16, 2001 5:19 AM
> > Subject: Re: [IBO] Editing a JOIN - Andreas
> >
> >
> > > Andreas; would it be possible, if the join was displayed in a
> grid, to edit
> > > the CALLER info, or to even insert a new caller into the CALLER
> table from
> > > within the grid, instead of having to do this from another place
> of input?
> > >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>