Context: ADO + SQL Server.

I have a join with two tables. The second table contains description of a numeric field of the first table. I used "Unique Table" run-time property and the "Add" operation works, but the problem is that after the update, the related fields of the secondary table are not visible on the Datagrid (and they are really Null on the ADO recordset).

I know I could do a Requery, but since I'm inside a transaction with update batch mode, this simple solution isn't possibile because i would lose every pending changes on other records.
The only solution I found is using a static FlexGrid, but it's really expensive...

What else can I do ?
Many thanks in advance.