Link to home
Create AccountLog in
Avatar of Fordraiders
FordraidersFlag for United States of America

asked on

Update query involving 2 tables

access 2013

I have database:
2 tables

tbl_Slang
3 fields
id-autonumber
fldSlang -text
fldDescriptor - text

tbl_Data
3 fields
id-autonumber
fldDescriptor
fldTerm

fldDescriptor is the common field between the two tables




What I need:
I need a vba routine that will update a field in tbl_Data(fldTerm)
with the data from the field fldSlang from the tbl_Slang Table


tbl_Slang:
fldSlang                                     fldDescriptor
TUG BOATS                                Switch Grip-lok Handy Box
TUGGER                                       Cable Puller
VERMITTI                                        Platform Lifter
WHIP                                          Electrode Holder

Before Update:


tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box
Cable Puller
Platform Lifter
Electrode Holder


After Update:

tbl_Data
fldDescriptor                                fldTerm
Switch Grip-lok Handy Box           TUGBOATS
Cable Puller                                  TUGGER
Platform Lifter                              VERMITTI
Electrode Holder                           WHIP

Thanks
fordraiders
ASKER CERTIFIED SOLUTION
Avatar of Flyster
Flyster
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Fordraiders

ASKER

Thanks very much