Hi VB Gurus,

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.

Please help me...

Thanks a lot,
Biju

mbws@batelco.com.bh