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