Hi,

In order to avoid lookup-fields I want to make a query with joins
which must be updatable in IB-objects. I tried to figure it out with
joins and keyrelations but I don't get it. Are there any examples how
to use those fields ? What I want to do is something like:

SELECT
a.order,b.name,c.description
FROM
tableA a, tableB b, tableC c
WHERE
a.orderID := b.orderID
AND
a.orderID := c.orderID

So, b.name and c.description are fields I don't want to update, but
tableA (a.order and a.adress) must be insertable and updateable

Leon