MainQuery is qryMemberBen:-
SQL =
SELECT
MEMBERBEN.MEMBERID
, MEMBERBEN.RELATIVETYPEID
, MEMBERBEN.OPTIONID
, MEMBERBEN.FUNDID
, MEMBERBEN.BANKID
, MEMBERBEN.BRANCHCODE
, MEMBERBEN.ACOUNTNO
, MEMBERBEN.ACCOUNTTYPEID
, MEMBERBEN.BENID

, Beneficiary.ID
, Beneficiary.TITLEID
, Beneficiary.INITIALS
, Beneficiary.FIRSTNAME
, Beneficiary.SURNAME
, Beneficiary.HOMETEL
, Beneficiary.WORKTEL
, Beneficiary.EMAIL
, Beneficiary.LANGUAGEID
, Beneficiary.RSTREET1
, Beneficiary.RSTREET2
, Beneficiary.RCOUNTRYID
, Beneficiary.RPROVINCEID
, Beneficiary.RCITYID
, Beneficiary.RSUBURBID

,(SELECT TITLE
FROM TITLE t
WHERE t.TITLEID=e.TITLEID) AS BEN_TITLE

FROM MEMBERBEN b

JOIN Beneficiary e
ON (Beneficiary.BENID = MEMBERBEN.BENID)

WHERE (MEMBERBEN.MEMBERID = :MEMBERID)
AND (MEMBERBEN.OPTIONID = :OPTIONID)
AND (MEMBERBEN.FUNDID = :FUNDID)

KeyLinks for qryMemberBen :-
MEMBERID
BENID
OPTIONID
FUNDID

UpdateSQL :-
EXECUTE PROCEDURE UpdateBen (:TitleID, :Old.TitleId)


qryTitle SQL=
SELECT * FROM TITLE

KeyLinks:-
TITLEID=QRYMEMBERBEN.TITLEID

KeyDescLinks :-
TitleName=QRYMEMBERBEN.BEN_TITLE

The qryMemberBen is a dataset I create in the app(see my previous question
about this).
Title test is tagged as COMPUTED.

Thanks and Cheers,
Dion.

-----Original Message-----
From: Helen Borrie (TeamIBO) [mailto:helebor@...]
Sent: Sunday, January 20, 2002 2:53 PM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] Grid lookup


At 11:19 AM 20-01-02 -0800, you wrote:

>Hi Helen,
>
>Can you actually reference a joined table in the KeyLinks(ie not a physical
>table in the database, but a virtual one, in this case MainQuery)? Either
>way I get an error saying that the field qryMemberBen.TitleID(or MemberBen,
>in the KeyLinks for the lookup dataset) is not found...

Are you by any chance attempting to edit this dataset without having custom
update SQL defined for it? i.e. is this error appearing when you try to use
the lookup?

Is the subqueried Title text column in MainQuery tagged in ColumnAttributes
as COMPUTED?

Or are you getting this error at design-time?

Could we have a look at the statements for both MainQuery and the lookup?

regards,
Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at
www.ibobjects.com



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/