Hi Randy,
I have tried using views and theres no problem when deleting them.
I think what you can do is, you can issue the zap command on your details table(line items). Or you can use a temporary table with the same structure of your line items table, then when your user cancel the transactions just issue the zap command.
Other thing is using select * from table_name into cursor lv_ordlines readwrite, then use that tmp cursor to store your line items.
readwrite works only on VFP7 or higher
When your user finalized the transaction just append to the real line items tables. If they cancel the transaction, just issue close the cursor then issue again select statements.
Im using this on my programs when it comes to Inventory Management & POS.
Just try if suitable to you.
Best Regards,
Jojo R. dela Cuesta
Dalplus Technologies
http://www.dalplus.com