complex datagrid problem

[ahsan]

Hi All!
I m developing an inventory control system as semester project 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) Customers
2) Products
3) Purchase_Master
4) Purchase_Details

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

Current:
--------
ID---------Master_Table_ID-------------Product_ID------------Qty
Int---------------int(referenced) ----------int (referenced)

Required:
---------
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, and product_name field exists in "Product" Table

Thanks in adavance

 

[ahsan]

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