peace!!!
i have this product table and a purchase table.... im going to display all the products to a grid and im going to update the price and quantity of each product, then i have a "purchased by" information entry also. and im going to save the updated products and the "purchased info" to purchased table.

&& heres the table-purchased look like

purchased id name product quantity price
1101 joe apple 5 20
1101 joe mango 3 10
1101 joe banana 6 15

&& table-product
product_id product_name
p101 apple
p102 mango
p103 banana


&&& the entry form
_______________________________________________________________
purchased id: 1101
name : joe

&&& grid
_______________________________________________________________
product id product name quantity price
p101 apple ____ ____
p102 mango ____ ____
p103 banana ____ ____
_______________________________________________________________


is it possible to save all this information in one table? and how to do it?
thnx!!!