have 2 tables a and b.
table a has two fields name and date/ name is key
table b has two fields name and address/ name is key
the two tables are related namy to one.

what I want to do is enter name in A and have the same entry entered
automatically in B.

Any suggestions to this obvious question would be appreciated.

Hi:
If you use a form to enter into table a, you could use the after
insert event to put the entry into table b. In that event you could
use code to enter into table b. If you are not a coder you could
write an append query and use "docmd.openquery" in the event to insert
the record into table b.
In the latter case you would use fields from the form as the source in
the append query.

If this doesn't make any sense send me an email and I'll send you a
sample.

Good luck
Ira Solomon

On Thu, 27 Oct 2005 17:49:26 -0700, Judy <> wrote: