In a form, I have 4 datagrid control. First one contains data from Master table. Second one should have data from the members of the Master record.

There are more members in one masters. One to Many relationship.

In the first datagrid control, there are Add, Edit & Delete option to manage the master record.

Once the master is added.It will show up in first grid. When I highlight one master record and rightclick on grid 2, Add Member form will pop up. 

It should have prefilled with Master name and Master Number. As I said, datagrid 2 is based on Master_Member table. At this point,Master name and number is available in Master Record only. Therefore, I need to create the left outer join to Master to  get the master name and master number from Master record. When I try that, it doesn't work. Even the changes in Text property is not saved.  Somehow it vanishes from the design.

Please help

Thanks

Gopinath Srinivasan