I'm starting to work on an account receivables system and I'm looking for suggestions as to how to proceed. There is a large table that contains "batches" of A/R transactions. A user can modify existing batches or create new ones. I am thinking of using views for this. If the user is modifying an existing batch I can put that batch into a view and then update the table when they are through. There is one thing I'm not sure how to handle - if the user is entering (or modifying) a large batch and the system crashes, I need to be able to retrieve the data that was entered. Is there some way to do this easily, or should I copy the view to a temp file periodically? Any advice would be appreciated.
Thanks
Elyse
Elyse Pomerantz