Hi All!
I m developing an inventory control system in vb.net and need a lot of support from u guys, thanks in advance.

Well i m facing problem in datagrid for displaying data from referenced (relation) tables. No! i m not talking about Master-Details transactions datagrid, rather 1 step further.

I have 4 tables:

1) Vendors
2) Products
3) Purchase_Master
4) Purchase_Details

Relations:
----------
Purchase Master -> Vendors
Purchase Master -> Purchase_Details
Purchase Details -> Products

Purchase_Details Table:
--------
ID---------Master_Table_ID-------------Product_ID------------Qty
Int---------------int(referenced) ----------int (referenced)

Required UI:
---------
ID------Master_Table_ID----------Product_ID-----------Product_Name -------Qty
14---------1-------------------------3-------------------Aldomat Tablet -----100

After creating relations, the form grid works fine.
But the purchase_details grid shows only "ID" (referenced_key) of products table which is not applicable by the user. user wants item by description.

In other words, while entering items, the purchase_detail_datagrid shows id of the product and quantity, but entry by product name is required (by selection) , and product_name field exists in "Product" Table. further, product_description field is only for disply in transactions table.

Guys!
C'mon, i need atleast few hints from u gurus
A little help may save Hulk from Little Red Riding Hood