I need to get a table on my Form that has different columns from differen tables.
As I call many tables by their Identity ID, I also need a way to show the information from that table.


I created a query in my TableAdapter which selects information from 2 different tables. Tested it in the query builder and all was OK.
I tried to put an empty DataGridView onto my Form and inserted the correct BindingSource for my Data Source.
I then added a query and selected the query I created in my TableAdapter.

But, when I ran the program, I got an error:
"Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints."

Weird, because it showed the correct data when I ran the query in The Query Builder....