Querying a table to modify another table
I'm normalizing tables. I will eventually delete field1
and field2 in one table so that I can use field6 as the
relational link in a 1 to many relationship.
Quote:
>-----Original Message-----
>Why would you need field6 in two places if they both
aren't updated at the
Quote:
>same time? Can't you just establish a relationship
between the the two
>tables and get the value from the one copy of field6
whenever needed?
>Mich
>> What is the best way to modify a field in one database
>> based on values in another? I need to scan all the
>> records in two large tables and apply the following
>> criteria:
>> For each record in TableA,
>> if field1 and field2 of TableA match field1 and field2
of
>> TableB,
>> then copy the value of field6 in TableA to field6 in
>> TableB
>> Thanks for any suggestions you can give me.
>> Jim Levitt
>.
