Dataset Relations null reference error =(

[SA_DUDE]

For purposes of getting this to work, I have two tables in a SQL
database.

Car:
idCars uniqueidentifier
idColour uniqueidentifier
RegNumber nchar(10)

Colour:
idColour uniqueidentifier
Name varchar(50)
I have added them both to a DataSet in C# 2005, it automatically picks
up the relation from SQL.

But then I run the following code:

DataSet1.CarDataTable carDataTable = new DataSet1.CarDataTable();
DataSet1TableAdapters.CarTableAdapter carTableAdapter = new
Test_SQL_Relationship.DataSet1TableAdapters.CarTab leAdapter();
carTableAdapter.Fill(carDataTable);

foreach (DataSet1.CarRow row in carDataTable.Rows)
{
MessageBox.Show(row.ColourRow.Name);
}

I get a "Object reference not set to an instance of an object." error,
it does not seem to load the row from the Colour table. If I run the
query in SQL it works 100%.

Can someone PLEASE help, I'm going to pull all my hair out at this
rate!

Thanks a million in advance!