question on copying records between 2 datagrids

[TM]

I have two datagrids in my application where one grid is for the master item
list and the second grid is for a shopping list.

I would like to click on a button and copy items from the master list to the
shopping list. Both are tied to tables in the same access mdb file.

How can I copy a record from one to the other ?

Is there some where that I can find out how to work with the records in the
data grids, such as saving them back to the database files, adding/deleting
records and such ?

Thanks

 

[Cor]

Hi TM

In the DataAccess tab for window forms and in the webdebelopment part for a
webform are samples
Build a Master Detail Window/Webform

http://msdn.microsoft.com/vbasic/vbrkit/default.aspx

I hope this helps a little bit?

Cor
"

 

[TM]

I found it/ and will check it out right away.

Thanks

 

[TM]

Although the samples are very interesting, they do not really apply to my
situation.

The two tables in my database are not tied together or have any
relationships.

I just want to basically build a shopping list from my master items list.
Then I want to print the shopping list by pasting the data into an excel
sheet where I have the needed formatting and page layout.

I want to save the shopping list because it is very possible to start
building the list and come back to it at a later time.

I just want to take the master list, click on a button to add that item to
the shopping list, then go on till the shopping list is completed. Of
course I have to be able to maintain both lists by adding and removing
items. I will also need the ability to completely clear the shopping list
so when I start a new trip, I can start with a clean slate.
I hope this clears things up a little.