>TRANSACT isn't included in my project though and I am not sure if I want it to be. There are some production machines that get their data from the tranact table and I don't want to accidentally lock it or anything.

You have to be able to refer to the transact table in code, or you won't be able to write to it at all. It doesn't have to be in the project manager.

To minimize locking, try this...

SELECT YOURCURSOR
SCATTER MEMVAR MEMO
INSERT INTO TRANSACT FROM MEMVAR