>Can some one tell me how to display fields
>from two related tables in a DBGrid in VB5?
>I am writing an SQL in the .RecordSource with
>a join condition.
>
>For example, to show the ItemNo from OrderDetail
>and the ItemName from ItemMaster.
>
>Though the records are visible in the grid,
>I am not able to edit any fields! If I remove
>the join with ItemMaster I am able to edit it!
>I checked the properties of DBGrid and everything
>seems okay. I don't know where I am going wrong.
Just curious, what is the technique you use to SQLUpdate the change made to several records in the grid?
As for us, I don't know if this is related, but we moved to True DB Grid Pro where we found that all our restrictions from the bundled version in Visual Studio were removed. However, we don't have a need to edit from the grid.