Main Form/Data Grid

[LonnieJohnson]

I have a main form that has customer information. I want a data grid that has realted records (expenses). I have a data adapter and dataset for the main customer record. Do I need a second data adapter and data set for my datagrid or can I use the same ones?

p.s.: I am new to this.

Thanks.

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[Korach]

You can use the same data adapter and replace the select command.
You can use a single dataset with two tables. Table1 for the customer and Table2 for the expenses. When you set the data source of the grid, set it to Table2, not the dataset itself.