Terry,
Hi! Thanks to your advise man... could you please give me a sample command syntax???

By the way, im using a free table....

I have this another question, im going to locate first the products by their category(product table), and then append those products as well as the information about the purchaser to purchased table and then after appending to the purchased table im going to display the products to the grid. and that is the time that im going to input a quantity and price(on the grid).

Now my question, how to append those products(e.g. 5 products)into the purchased table with only one purchaser?

this will my form look like:

Transaction no:1
Name: Joe

&&grid

-products-----quantity----price

--apple----------10---------20
--mango----------10---------25

thank you!!!

Have a nice day man!!!

jan