I want to add a column to a TIB_Grid that is currently displaying the
contents of table A via an TIB_Query. The new column is from table B
which is linked to A with a foreign key.

The problem is that there isn't necessarily a record in table B
corresponding to each item in A. Also there may be multiple B items
corresponding to an A item. If I do a join, I don't see the A items
that lack an entry in B. If I do a left join, I get multiple rows for
the A items that have multiple B entries.

Any pointers from the experts would be appreciated.

Thanks