Thanks Geoff,

>Do you understand that when you input a table_name.field_name
>definition it is the actual table name and NOT the query/datasource

Yes I do. Many, many thanks guys(Geoff). It works now!!

Cheers,
Dion.



-----Original Message-----
From: Geoff Worboys (TeamIBO) [mailto:geoff@...]
Sent: Wednesday, January 23, 2002 3:00 AM
To: Dion
Subject: Re: [IBO] Grid lookup Please!!!


Hi Dion,

Firstly...

Do you understand that when you input a table_name.field_name
definition it is the actual table name and NOT the query/datasource
component name? IBO only requires the table_name.field_name (instead
of just field_name) with joins, in order to distinguish fields from
one table or another out of the join.

(A couple of previous postings looked like you were using component
names and not table names.)


Secondly...

Fields derived from embedded selects dont have a table name, so you
cant use the table_name.field_name format in the link definition.
(This has caught me several times :-)

eg: in the keydesclinks of a lookup dataset:

My_Lookup_Key_Field=Main_Table_Name.Embedded_Select_Field

will not work. You need just:

My_Lookup_Key_Field=Embedded_Select_Field

You can use joins rather than embedded selects to derive the required
field - and the resulting field will have a table name (of the joined
table).


Does this help?

--
Geoff Worboys - TeamIBO
Telesis Computing


___________________________________________________________________________
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/


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 01/11/2002

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.314 / Virus Database: 175 - Release Date: 01/11/2002