To recreate the problem:

create table SST_Contact (
ContactID Integer not null primary key,
Name VarChar(10),
Surname VarChar(10),
FullName computed by (Name || ' ' || Surname)
);


create table SST_Subs (
SubsID Integer not null primary key,
ContactID integer,
constraint SST_FKey1 foreign key (ContactID)
references SST_Contact (ContactID)
);


Then create a form with TIB_Connection, TIB_Transaction, TIB_Query and
link them up. Enter the following statement into the SQL property:

select
C.FullName,
S.ContactID
from
SST_Subs S
join SST_Contact C on
C.ContactID = S.ContactID

You can't prepare the query. IBObjects incorrectly states:

Fieldname: SST_CONTACT.FULLNAME not found.

Prepare isn't the real problem. Drop a TIB_Datasource and TIB_Grid
and link them up as well. The TIB_Query won't open now.

Any ideas?

Regards,

Ian