The schema returned by the new query differs from the base query error
Posted on 2008-10-22
Let's say I have these 2 tables
FName LName Status Idstat Desc
John Smith 1 1 ACTIVE
Mark Doe 2 2 INACTIVE
Then I aded a Datagrid into the form and bind it to the Table1 binding source and then
I tried to add a Query joining these 2 table and all field form Table1 and showing the Desc field from table2
and I got the "The schema returned by the new query differs from the base query error"
Now How do I get the Query to work on the grid, I've read that is better to build the datagrid programmatically instead of drag and drop into the form and assigned the query by code.