I have two(2) tables, one is a Prospective Clients Table and the other is an Active Clients Service Table. Can I program Access to, for example,Place the Company name automatically in the second Table when I want it to or as I type it in the first Table? Can somebody give me an explanation and/or some keywords to help.
Regards Paul
If you are asking if Access can add a record to another table when a record is added to the first table, then the answer is no. That functionality, triggers, is not a part of Access. However, if you are entering data into Access thru an application, it would be relatively simple to add code to the After_Update event (in pure Access) or after your rs.Update method call in VB to also add a record to the second table.
Hope this helps.
Bash