To all,

I am having a problem with the standard invoice type application. It has a master with several
related tables such as Vendor, Account, Special Tracking, etc. And the children are almost
mirroring the master yet contain a part number, a quantity, a unit cost and a cost. It also has
separate account and special tracking fields for multiple history lists.

The problem I am getting is that when a user has added a new base invoice they then save it and
drop to the bottom of the window and enter the first line item for that invoice. ( A grid is below the
specific line item info, for such as multiple line description) As soon as they save the line item it
is causing the base invoice record to jump to another record and it has that same line item, just
added, linked to it. The wrong base with the wrong line item.

I have one each TIB_Query for the Base, Base Acct, Base Special, and Base Vendor with each having
a separate TIB_Connection. The Acct, Special, and Vendor master-link to the base TIB_Datasource.
The line item is much the same way but the line item also links to the Invoice TIB_Datasource. It
also has a TIB_Query for the Item, Special and Acct. With separate TIB_Transactions.

All are set to Autocommit, and tiCommitted. All queries are set to caRefresh. raKeepDataPosOrRowNum,
and PreparedEdits, and Inserts.

Do I have enough TIB_Transactions, to few, or too many?

Thanks...