I have a form which displays related data from three different tables. There is a foreign key between the master table and the two related. Currently I have three stored procedures to return the data based of the return key value from a search. Because I am using DataAdapters to select and modified the recordsets I need three sepearte datasets. This works great, but I'm sure adds a lot of overhead. In VB 2008 with SQL 2008, is there a way I could use only one stored procedure to accomplish this?
Thanks
Charles