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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
chenr said:
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.
Click to expand...

That should not be hard to do with a Query, assuming the relationships
are in order.

However it sounds like you may have a table design issue that you may
want to address and eliminate the need for the question.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I copy the ID field into another table in the same databas 2
An unbounded field can bring the record to another 2
Appending records to new table using field names as values 2
2 fields, 2 tables, one update 2
Syncronizing data field from one table field to another table 1
Count of records and Update 3
Create a table based on another table. 3
Error message: Field cannot be updated 3

Back
Top