Fillings in forms

  • Thread starter Thread starter John
  • Start date Start date
J

John

Very basic question (I think). I have two daatabases and
forms: a Client Database and form and an Activity
database and form. When I fill in the Social Security
Number of the Client in the Activity form, I would like
the Name, Address, etc. to fill into the respective areas
to be filled in also from the information on the Client
database. I only have one entry per client in the Client
database but will have many entries of Activity for the
same client.

Thanks.
 
i'm wondering why you have these two tables - Client and
Activity - in different databases. but since you do,
suggest you link the Client table into the Activity
database. also suggest you do NOT copy each client's
address info into fields in the Activity table (unless you
need a "point in time" record, for some reason). the
linked table will provide the address info whenever you
need to display it on a form or report, in the Activites
database.
hth
 
Back
Top