Can Access be programed to place input data in a number of tables?

[Paul Dudley]

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