OK but I think I am having trouble with it filling the correct BO since I am using the same Sub to fill multiple BO's but I will try again and see what happens. Thanks.

Terry,

Your code is using the objbo.FillDataTable(cmd) instead of Me.FillDataTable(cmd).

Here is how it should be.  If you put a break in Me.FillDataTable(cmd) then see the value of cmd.Commandtext, notice that the correct table for the instance of the BO is used, remember "Generic", each BO is created for a specific table, hence the String.Format() code, so when you drop a BO and run the FillAllData() it will work just fine.  It is a good idea to take a look at the SF source code to learn how they use this generic logic for the FillBy... methods in the BO class.

    Public Overridable Sub FillAllData()
        Using cmd As New SqlCommand()
            cmd.CommandType = CommandType.Text
            cmd.CommandText = String.Format("Select * From {0}", Me.TableNameAndSchema)
 
            Me.FillDataTable(cmd)
        End Using
    End Sub

Edhy Rijo