Master detail form

Hi,

I want to create the age old master-detail form. Where I want to add/update/delete records into two tables simultaneously. I want to use a textbox/datalist control for displaying a record of the master table and a datagrid for the detail section.

I know I have to create a dataset with two tables and create a relation between them. But I need some tips regarding how to go about. Is there any article on the web about this. Any pointers will be appreciated.

Thanks in advance,Inside theServer-Side Data Access QuickStart tutorials is a section onWorking with Master-Detail Relationships.

I hope this helps.
Thanks , I had a look. But the following link gave me more info :

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbcon/html/vbwlkwalkthroughcreatingmaster-detailwindowsform.asp
I tried the sample but I am getting the following error :
Login failed for user sa and the source of the error is microsoft OleDB provider for SQL server. Do I need to create a ASPNET user in SQL server ??

Thanks in advance,
> Do I need to create a ASPNET user in SQL server ??

Yes.

If you need,this message showed me how to add the ASP.NET user ...
Even after creating a ASPNET account in the SQL server, I continue to get the error, I don't know why ?
What is your connection string? If the error says "Login failed for user sa" then you are not using the ASPNET account. Hence, make sure that you are supplying the correct password for the sa account in the connection string.
Thanks, I did examine the connection string and found that the password was missing, I had used the Data Adapter configuration wizard to create the connection and the dataadapter so I assumed that the connection string would be OK.