Hello,

I think that using a INNER JOIN is the cleanest way to do a relation
beteween two tables.
I'm using a IBDataset component to supply a DBGrid but it's not
updating the related (JOINED) column after a insert.
I don't think that relating the columns into the dataset component
(creating a virtual field) is a clean way but now it is the only way
that it is working.

This is the SQL statement example:
"SELECT ENTRITEM.*, PROD.DSCR AS PRODDSCR FROM ENTRITEM INNER JOIN
PROD ON (PROD.PROD = ENTRITEM.PROD)"

Thank you all for the help!

--

..::
Marcello Fontolan
marcello@...
::..