How can I Update one field of a record depend on another field

C

chenr

Hi, friends:

My question is
I have 2 tables in my database,
I wish when I update the field in the first table, the another field in the
second table can automatically update.

Please help, very thanks.
 
S

Sergey Poberezovskiy

AFAIK, triggers do not exist in Access database;
so if you want to have the functionality you described,
you will have to write some code and then call this code
whenever you need to update the first table.

HTH
 
Top