I created a database table Stock/Products/Sales

Stock table Products Sales
----------------- ----------------------- ----------
StockID ProductID SalesId
Category: Product-category Product Type
Product : Product Qty
Date: Quantity Price
Quantity: Price
Price:
------------------ ------------------------ ------------------
.
Can anyone explain a little how to bind tables with each other example Products getdetails from Stock,Sales getdetails from Product.