Thanks; I will try it.

>Hilmar,
>
>I'm not 100% sure about this, but I don't think you have to change that at all. All you have to do is change the query. The literal Student in line 4 is telling the data adapter what to call the data table created by the query and line 6 is telling the grid which data table to use from the data set. Line 4 would be comparable to this in VFP with SPT:
>

>SQLEXEC(handle, query, 'Student')
>

>So, it doesn't really matter what you call as long as you use the same thing in both places.
>
>HTH,
>Chad
>
>
>>I have loaded a grid with data from a single table, and would like to know what adaptations are required to use a multi-table join.
>>
>>What I have is something like this:
>>
>>

>>String query = "select * from Student order by LastName";
>>da = new OleDbDataAdapter(query, Cn);
>>ds = new DataSet();
>>da.Fill(ds, "Student");
>>this.dataGrid.DataSource = ds;
>>this.dataGrid.DataMember = "Student";
>>

>>
>>Data is stored in Access. I don't think I would have trouble with the JOIN (unless Access syntax is significantly different from Visual FoxPro), but:
>>
>>What should I replace for "Student" in lines 4 and 6, if the query spans 2 or more tables?
>>
>>TIA,
>>
>>Hilmar.