One way automatic merge

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

Guest

Can I fill in a table from another table automatically? However, I only want this to be a one way update. I have a table for referrals and one for customers, I want the referrals to become customers automatically but, I dont want the customers to become referrals
 
Nope.
Access/Jet does not support triggers on tables. (Access/SQL Server does.)
You have to use forms to simulate triggers.

Put code behind a Save button that adds the data to the "extra" table.
(Or some other event like Form Update)
--
Joe Fallon
Access MVP



mikeweide said:
Can I fill in a table from another table automatically? However, I only
Click to expand...
want this to be a one way update. I have a table for referrals and one for
customers, I want the referrals to become customers automatically but, I
dont want the customers to become referrals
 
Back
Top