And Prosperity!
Jan, look at creating a view. You can create it via the view builder dialog or via the "CREATE VIEW" command. Essentially views are ways of looking at related data, in different tables, selecting only the fields you want from each, and presenting them as one flat file. The source to you grid can be a view the same as a table.
to get gthe builder: On your project's data tab, drill down to "Local Views", right-click and select new.
HTH
Terry
>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!!!
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.