Re: [users] Oo base question-- how to merge databases

2006-05-15 Thread Dan Lewis
On Monday May 15 2006 01:23 pm, Ashley Oviatt wrote: > I have 2 databases (db1 and db2) with a common field (ACCOUNTNO) between > them. In db 1, there is a field called key5 that is a customer number. I > want to add a new field in db 2 that is called key5 and populate that > field with the info fr

[users] Oo base question-- how to merge databases

2006-05-15 Thread Ashley Oviatt
I have 2 databases (db1 and db2) with a common field (ACCOUNTNO) between them. In db 1, there is a field called key5 that is a customer number. I want to add a new field in db 2 that is called key5 and populate that field with the info from key 5 in db 1. I have to base it on the ACCOUNTNO fiel