Subject Refresh on insert for joined table
Author Rick Roen
D7 IBO4.5B XP SP2

I have an order entry program with the following two tables:

OrderItems - INVOICENUM, ITEMNUM, QTY_ORDER, QTY_SHIP, RETAIL, ...
Packet - ITEMNUM, DESCRIPTION, RETAIL, ...

For displaying the items in the order I do a join like:

Select OI.INVOICENUM, OI.ITEMNUM, P.DESCRIPTION, OI.QTY_ORDER,
OI.QTY_SHIP, ...
From ORDERITEMS OI
Join PACKET P on P.ITEMNUM = OI.ITEMNUM
Where OI.INVOICENUM = :INVOICENUM

This IB_Query component feeds both a grid and IB_Edit boxes for
editing/inserting.

Everything is fine for display purposes in the grid and edit boxes,
however I can't get the Inserting to act like I want. When the user
adds a new record into a TEdit I verify that the ITEMNUM exists in
the Packet table (a separate IB_Query) Then insert a new record with
some default values for QTY_ORDER, QTY_SHIP etc. The IB_EDIT that
shows the P.DESCRIPTION does not show the Packet description while
in insert mode which is confusing to the user. I would like to
refresh the query somehow to the Joined Packet table Description
field is shown, but a Refresh on the table ( with raKeepDataPos )
only commits the new record since I have the transaction on
AutoCommit.

Is there some other way to get the joined Packet.Description to show
before the commit?

Rick