Copy to another table

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

Guest

I have one table (contacts) that contains information of people before they
apply to a program. I have a second table (Applicants) that will contain the
same information in the contacts table, but only if they have applied. Is
there a way I can create a macro to run off of a form to automatically copy
the record being viewed to the Applicants table?

Thanks,
Kevin
 
have you considered using just one table for "people", and adding a Yes/No
field named Applied, where Yes = person has applied. or perhaps a Date/Time
field, named ApplicationDate, where the Date or Date and Time is entered
only when the person applies? or you could even use a Status field instead,
so when a person's data is initially entered in the table the status of the
record is Contact - and when that person actually applies, the status is
changed to Applicant.

any of the above fields would be very easy to query against, to return all
persons who are contacts, or all persons who are applicants.

hth
 
Back
Top