Can you describe the best (or your preferred) method for updating data held in a related table using Visual Studio 2005 and SQL Server.

For example; if you had a stock control system with the product names and current stock levels in one table and all stock movements in and out in another table, what is the best, fastest, safest and most reliable method of inserting a stock movement and then updating the current stock level?

I have tried a couple of different methods but would really appreciate a wider range of opinions and methods.

Thanks

Tim

__________________
Try our latest project www.nobanx.com Currency Exchange for members