hi aamir, u need to JOin the tables in order to retrieve the supplierName,
u can achive this using Select Statement with Inner join
suppose there are two table
1) SupplierMaster [with fileds]
i.Inv_id
ii. sName
iii. othersfields
2) bill [with fileds]
i. billno
ii.inv_id
iii. other fields
--------------------
Your SQL select Statement will look like this
SELECT a.billno AS [Bill no], b.sName AS [Supplier] FROM bill AS a INNER JOIN SupplierMaster AS B on a.inv_id=b.inv_id
use this query to bind ur grid
and let me know u found the solution or not