Currently im learning to use the application development of VisualStudio 2005

i have created a basic local database with two forms, customer and order, with the obvious fields, CustomerID, Firstname etc in the Customer form. In the Order form i have OrderID(PK), CustomerID, Products, etc etc. I have setup my dataset and i have drag from the dataset to the form. i can input data in the form when running and it carrys the primary key through from Customer table to Order table and works fine. yet when i use the save button from the navigation bar that was automatically added to the form it does not save this data once i input test values.

Ive tried multiple tutorial videos from Microsoft C# express and VS help and i have even gone as far as using Visual Stuidos inbuilt 'howto' online help...which is useless to me

From this i would like to add two buttons which when clicked will save(update) and delete data to BOTH the tables.

Help with what code i need to put behind these two buttons would be much appreiciated.

Thanks

Cass

If any other information about my setup is needed just ask.

Had you considered creating a stored procedure that will accept input parameters to Update and Delete data from both tables?? This seems to be the most obvious route.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
Technical Editor for: Professional Search Engine Optimization with ASP.NET
http://www.wiley.com/WileyCDA/WileyT...470131470.html
================================================== =========
Why can't Programmers, program??
http://www.codinghorror.com/blog/archives/000781.html
================================================== =========

you could also just use an SQL statement that was hard coded into the code if you are not familiar with stored procedures.