updating/adding accees DB with VB

[DylanE]

I know this has been discussed before as I have read most of them including some tutorials. I haven't been able to find anything that fits my particular situation. Here's my question.

I have an access database with 2 tables. One table contains names. The other contain 3 fields that are linked by name. I'm using ADO in VB. What I want to be able to do is add information to the 3 fields that are linked to the name. So if name = "Dave" then addnewrecord to the the 3 fields. The 3 fields will not get overwritten, just added to. So dave could have 20+ sets of these 3 fields. The information for the 3 fields will come from varaibles and lable captions.

If anyone has some ideas they can give me or point me in a direction I would appreciate it.

Thanks,

Dylan

[Hack]

How is name in table1 linked to table2?

If I were to open table2, how would I know what sets of records went with what name in table1?

[DylanE]

Both tables have the name field and are linked that way