Daniel,

Daniel Rail schrieb:


[snip]

>
> When reading the query that is automatically generated by IBO:
> SELECT First NAME PARENTS.FAMILY_ID
> FROM PARENTS
> WHERE PARENTS.FAMILY_ID=?
>
> I can see why the error occurs. What I'm finding odd, is that there
> is no field called NAME in that table, or any table in the database.
> I do have fields containing NAME in them(PG1_FIRSTNAME, PG1_LASTNAME,
> PG2_FIRSTNAME and PG2_LASTNAME), and those fields do have display and
> grid labels(i.e. "Parent/Guardian No.1 - First Name").
>
> Is there an explanation why the above query might be generated as it
> is?

What about the OrderingItems - how are they defined?

Luc.