<http://imageshack.us/photo/my-images/837/6uvs.jpg/>

I have the following tables and relationships.

When loading the NEW\_CHALLAN form, I am trying to fill a Grid View with Product Details - Product Name, Stage, Pro, Katta, Packing, Rate, Quantity.

I am facing a problem (getting 0 records as result set) when using JOIN for this operation as there are no matching records(ChallanId, ProductId, OrderId) in the ChallanProductDetails table yet (when loading the form)

Any suggestions on how to solve this problem ?