Automatically change value in field

G

GregB

I have two tables.
Table 1 contains two fields: serial number and status

Now, if someone enters a serial number into table 2 that is already in table
1 then that status in table 1 will automatically change. How can I make this
happen?

Thanks for any help!!

Awsome community
 
J

Jeff Boyce

Access tables don't have triggers like SQL-Server tables do.

If you want someone to enter (?perhaps "select" instead of "enter"?) an ID
and have a status field in a table get updated, take a look at Access Forms.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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

Merge Tables? 7
Access Macro Repeat Expression using value of a field in table 0
update a multiple fields 3
How to Populate Data from a table to another 0
linked text box to table 11
Design Question- allow schedule to match SN furthest in mfg proces 1
auto number in query 1
Two fields to one record 1

Top