I have a grid that is using a BusinessBindingSource. Works fine if I am taking all fields from the standard BO. I want to add one extra field, which is taken from another table , so I have changed my select statement whcih popualates the BO, to do a join to the lookup table

myGrid.DataSource = this.businessBindingSource1;
myBO1.FillDataTable("SELECT * FROM SCP JOIN KMA ON SCP_STKREF = KMA_STKREF");
(The Table SCP is the BO source in the Business Object mapper. I use the join just to get one lookup field)

In the Grid however, I still dont see the Description Field (Which comes from the Joined KMA table)

Other than the above, I have not made any changes to the BO.

Do I need to 'add' the extra field as a custom field in the BO ? If so, is there any C# code around that does this