Hey Guys.
I have two different tables, Appointments and Referrals. I need to use a SQL query so that the referral table automatically updates whenever an referral is added in the Appointments table. How can I do this?
Novice
Windows 7 64bit 
Access 2010 64bit
Hey Guys.
I have two different tables, Appointments and Referrals. I need to use a SQL query so that the referral table automatically updates whenever an referral is added in the Appointments table. How can I do this?
VIP
Windows XP Access 2010 32bit
You want it updated with what? How are the tables related?
You would have to execute an SQL update or insert action from some event such as a button Click or data control AfterUpdate or form Close. Maybe a form/subform arrangement is needed.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Form auto-updating from a query.
Posting Permissions
Reply With Quote